This article is written based on feedback I have received on SQL SERVER – Cannot resolve collation conflict for equal to operation. Many reader asked me how to find collation of current database. There are two different ways to find out SQL Server database collation.
1) Using T-SQL (My Recommendation)
Run following Script in Query Editor
SELECT DATABASEPROPERTYEX('AdventureWorks', 'Collation') SQLCollation;
ResultSet:
SQLCollation
————————————
SQL_Latin1_General_CP1_CI_AS
2) Using SQL Server Management Studio
Refer the following two diagram to find out the SQL Collation.
Write Click on Database
Click on Properties
Reference : Pinal Dave (https://blog.sqlauthority.com)
27 Comments. Leave new
regarding collation to find out case sensitive or in-sensitive, can we any other options in the place of CS or CI
Hi All,
I have a database in MSSQL Server 2008 that have 3 tables.
There is a column in each table that contains data in Hindi’s KurtiDev Font (non-unicode),
I want to convert that data into Unicode form.
please suggest me any tool or process to do my task.
Thanks in advance….
~S~
how to check what changed in db ?
hi,
Here in Greece, we have a huge problem with data inserted by users.
e.g. the user writes the name “ΑΛΕΞΑΝΔΡΟΣ” in a field.
The problem is that the first “A” is English, the rest in Greek.
Capital letter “A” ( like many other letters in English ) are visually similar,
but in an sql SELECT statement we don’t know what to write to find anything.
Is there any way to find character sequence that contain two or more different “charsets” ? the fields are NVARCHAR
thank you