Reputation: 17
I have a table in whicn one column need to be able to store a lot of different characters - cyrillic, chinese, swedish etc. Currently there is SQL_Latin1_General_CP1_CI_AS collation and it is not ideal. Microsoft recomends for swedish Finnish_Swedish_CI_AS. For chinese there is still option Latin1_General_CI_AI. But what collation can be used to display all of different characters? And is it bad decision to change collation for one column? Read info about not changing because of getting "cannot resolve collation conflict" errors.
Upvotes: 0
Views: 21