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,
insert into t
select N'?? ???? ???'
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');
ORDER BY Latin1_General_CI_AS;
ORDER BY SQL_Latin1_General_CP1_CI_AS;
DROP TABLE dbo.CollationDemo