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?

Improve company productivity with a Business Account.Sign Up

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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.