# Database Collation

Quick Answer: Turkish\_CI\_AS

**CI :** Case insensitive comparisons so 'ABC' would equal 'abc'

**AS** : Accent sensitive, so 'ü' does not equal 'u'

To view Collation of DB:

```sql
SELECT SERVERPROPERTY('collation') AS ServerCollation;
```

If you create a column without a specific collation, it will be listed as NULL in in sys.columns, meaning the collation of the column will be the same as the database default.

```sql
SELECT t.name TableName, c.name ColumnName, collation_name
FROM sys.columns c
inner join sys.tables t on c.object_id = t.object_id;
```

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1686757565725/6907485c-163e-4d9e-a720-14de9cf3e2ba.jpeg align="center")

### What is SQL\_Latin1\_General\_CP1\_CI\_AS stand for?

Breaks up into interesting parts:

* latin1 makes the server treat strings using charset latin 1, basically ascii
    
* CP1 stands for Code Page 1252
    
* CI case insensitive comparisons so 'ABC' would equal 'abc'
    
* AS accent sensitive, so 'ü' does not equal 'u'
    

[https://www.sqlshack.com/sql-server-collation-introduction-with-collate-sql-casting/](https://www.sqlshack.com/sql-server-collation-introduction-with-collate-sql-casting/)