This post show how work creating and inserting, selecting data from tables with the same name of table but with diffrent size of letters in this name.
In this topic I show You how create in SQL Server object with any collation or change collation in existing object.
The type of
COLLATE is important in compare values with low-hight letter, accent letter or diacritical letter.
COLLATE is a clause apply to the database, column or string expression, set collation for data.