While installing SQL Server, one of the parameters that is needed to be set during installation is Server collation. It is a parameter influencing the way in which SQL stores non-Unicode data. We may choose SQL Collation CZECH_CI_AS in Czech environments. While starting a database, we can also select collation that can be different to Collation SQL Server instance.
It is different with setting up a table though. Collation is taken by default from the database, however it is possible to select different collation for columns of the table.
CREATE TABLE [dbo].[Table]([Text_Czech] [varchar](8000) COLLATE Czech_CI_AS NULL,[Text_Japanese] [varchar](8000) COLLATE Japanese_CI_AS NULL) ON [PRIMARY]
