List database collation

From Robs_Wiki
Revision as of 10:02, 14 February 2020 by Qadmin wiki (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Introduction

a Collation is a configuration that determines how character data sorting is done. This is an important setting that has a huge impact on how the SQL Server database engine behaves in dealing with character data

SQL Azure default collation

The default collation for character data in SQL Azure databases is SQL_Latin1_General_CP1_CI_AS.

SELECT CONVERT (varchar(256), SERVERPROPERTY('collation'));  

SQL_Latin1_General_CP1_CI_AS