Difference between revisions of "List database collation"

From Robs_Wiki
Jump to: navigation, search
(Created page with "<pre> SELECT CONVERT (varchar(256), SERVERPROPERTY('collation')); SQL_Latin1_General_CP1_CI_AS </pre>")
 
 
Line 1: Line 1:
 +
__TOC__
 +
 +
== 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.
 
<pre>
 
<pre>
 
SELECT CONVERT (varchar(256), SERVERPROPERTY('collation'));   
 
SELECT CONVERT (varchar(256), SERVERPROPERTY('collation'));   

Latest revision as of 10:02, 14 February 2020

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