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]