July 3, 2002 at 1:51 am
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 ) ?
July 3, 2002 at 10:08 am
Not sure how you could do this. Maybe cast the column and see if that removes the collation?
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply