SQL Collation – How to Change Collation of Table Column

By | 18. 1. 2020

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.

SQL Collation

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]

5/5 - (1 vote)
Category: SQL Administration

About Jan Zedníček

My name is Jan Zedníček and I work as a freelancer. I have been working as a freelancer for many companies for more than 5 years. I used to work as a financial controller, analyst and manager at many different companies in field of banking and manufacturing. When I am not at work, I like playing volleyball, chess, doing a workout in the gym and I enjoy tasting of best quality rums. I am trying to summarize all my knowledge on this website not to forget them (because of the rum effect, you know =) and to put them forward to anyone. Don´t worry about asking for help or writing some comments.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.