Forum Discussion

takagiakira's avatar
takagiakira
Copper Contributor
Oct 08, 2020

SQL Server collation settings

Hello everyone.

 

SQLServer2016 or later.

 

I want the collation of objects to be Japanese_CI_AS and the collation of data to Japanese_CS_AS.
It's very difficult to change the collation of the data after creating the objects because there are so many objects and there are no rules for names.

 

Therefore, I thought that it would be better to set the collation order of objects and data in advance.
Can anyone please tell me if this setting is possible with SQL Server.

 

Thank you.

No RepliesBe the first to reply

Resources