SQL_Latin1_General_CP1_CI_AS
Latin1_General tellls us that the supported language is English.
CP1 - Stand for code page 1
There is no BIN in the collation name that means it supports Dictionary sorting.
in Dictionary Sorting; comparison of character data is based on dictionary order ('A' and 'a' < 'B' and 'b').
Dictionary order is default when no other ordering is defined explicitly.
If you see collation with BIN (e.g. Latin_1_General_BIN ) that means it will support binary sorting, In binary sorting; sorting is based on binary represenation of underlying characters ('A' < 'B' < 'a' < 'b').
CI means character data is case insensitive (that mean 'ABC' = 'abc').
AS means character data is accent sensitive ('à' <> 'ä').
--English characters will be sorted first as r default collation for the column is SQL_Latin1_General_CP1_CI_AS
create table t
(
ID int identity(1,1) primary key,
data nvarchar(30)
)
go
insert into t
select N'ABC'
union all
select N'PQR'
union all
select N'??????'
union all
select N'aaa'
union all
select N'?? ???? ???'
union all
select N'??? ????
'
select * from t order by data
DROP TABLE t
CREATE TABLE dbo.CollationDemo(
Latin1_General_CI_AS varchar(10) COLLATE Latin1_General_CI_AS
,SQL_Latin1_General_CP1_CI_AS varchar(10) COLLATE SQL_Latin1_General_CP1_CI_AS
);
INSERT INTO dbo.CollationDemo VALUES('CO-OP', 'CO-OP');
INSERT INTO dbo.CollationDemo VALUES('COOP', 'COOP');
SELECT *
FROM dbo.CollationDemo
ORDER BY Latin1_General_CI_AS;
SELECT *
FROM dbo.CollationDemo
ORDER BY SQL_Latin1_General_CP1_CI_AS;
DROP TABLE dbo.CollationDemo
--
Chandu
what is the use of sql_latin1_general_cp1_ci_as
Posted - 12/06/2012 : 03:55:13
