collation in Sql server. locale (Character set) in SQL Server
SQL_Latin1_General_CP1_CI_AS
where:
See doc: Windows Collation Name structure
select
name,
description,
CONVERT(varchar(100), COLLATIONPROPERTY(name, 'CodePage')) as codePage, -- Convert the variant data type to varchar in case your client does not support it
CONVERT(varchar(100), COLLATIONPROPERTY(name, 'LCID')) as LCID, -- See doc
CONVERT(varchar(100), COLLATIONPROPERTY(name, 'ComparisonStyle')) as ComparisonStyle, -- Ignore case : 1, Ignore accent : 2, Ignore Kana : 65536, Ignore width : 131072
CONVERT(varchar(100), COLLATIONPROPERTY(name, 'Version')) as Version -- version of the collation
from fn_HelpCollations();
Doc:
SELECT * FROM sys.fn_helpcollations() WHERE name NOT LIKE 'SQL%';
SELECT name FROM customer ORDER BY name COLLATE Latin1_General_CS_AI;