Tag: Collation Sequences

SQL Server 2008 R2- Find Database Collation

SQL, SQL-Advanced, SQL-Tips and Tricks, Varinder Sandhu

How to find collation of current database? There are two different ways to find out SQL Server database collation. Using T-SQL SELECT DATABASEPROPERTYEX('Database_Name', 'Collation') as SQLCollation; Using SQL Server Management Studio (SSMS) Right Click on the database Go to Properties You will get the dialog box as shown in the figure   You can execute the system function fn_helpcollations to retrieve a list of all the valid collation names for Windows collations and SQL Server collations: SELECT * FROM fn_helpcollations()

» Read more
,

SQL Server – Collation Sequences

SQL, SQL-Advanced, Varinder Sandhu

Collation sequence control how server treats character data for storage, retrieval, and sorting and comparison operation. SQL Server 2008 allows you to specific sequence to support any language currently used around the word. Collation sequence can be specified at instance, database, table and column level. The only collation sequence that is mandatory is defined at instance level, which defaults to all other level  unless it is overridden specifically. A Collation sequence defines the character set that is supported, including case

» Read more
, , ,