SQL Server collation settings

Occasional Visitor

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.

0 Replies