I create table with varchar column with a collation that differ from the database default , after that I created a view that select from that table with out specified any collation the result was that :
The column collation in table != the column collation in the view (collation conflict ) .
The view take the database default collation instead of the column collation .
There is a way to change view collation with out rewrite the view (since collation is not ansi and this view need to run against oracle too ) ?