Changing collation of existing view

Hi folks,
Is it possible to change the collation propert of an existing view? If yes, could you please describe how.
innocent1973Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
patriktConnect With a Mentor Commented:
No, COLLATE  is like a function so acts only on preceding expression.
But why do you need to convert all? Your table is wrong or other problem? May be there is simplier solution.
0
 
patriktCommented:
What is Collation of View? Do you mean collation of some column in result or order collation?
For changing collation you can use '<column> COLLATE <collation name> '. It will convert column output to desired collation.

Patrik
0
 
innocent1973Author Commented:
is it possible to convert all columns in once?
0
All Courses

From novice to tech pro — start learning today.