34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE MyTable
(PrimaryKey int PRIMARY KEY,
CharCol varchar(10)
)
GO
insert MyTable
select 1,'ABCD'
union all select 2,'abcd'
union all select 3, 'Abcd'
union all select 4, 'abCD'
select * from mytable where CharCol like 'A%'
/*
PrimaryKey CharCol
1 ABCD
2 abcd
3 Abcd
4 abCD
*/
修改前
ALTER TABLE MyTable ALTER COLUMN CharCol
varchar(10)COLLATE CHINESE_PRC_CS_AS NOT NULL
--建好表之后修改排序规则
---CHINESE_PRC_CS_AS区分大小写
select * from mytable where CharCol like 'A%'
/*
PrimaryKey CharCol
1 ABCD
3 Abcd
*/
CREATE TABLE MyTable
(PrimaryKey int PRIMARY KEY,
CharCol varchar(10) COLLATE CHINESE_PRC_CS_AS NOT NULL
)
GO
--建表时设置排序规则
ALTER TABLE MyTable ALTER COLUMN CharCol
varchar(10)COLLATE CHINESE_PRC_CS_AS NOT NULL
--建好表之后修改排序规则
---CHINESE_PRC_CS_AS区分大小写
GO
select distinct a from (
select item COLLATE CHINESE_PRC_CS_AS as a from
(select 'abc' COLLATE CHINESE_PRC_CS_AS item
union select 'Abc'
union select '百度') a
) as t
select distinct(item) from
(select 'abc' COLLATE CHINESE_PRC_CS_AS item
union select 'Abc'
union select N'百度') a
where item like 'A%'
--Abc
select distinct(item) collate Chinese_PRC_CS_AS from
(select 'abc' item
union all select 'Abc'
union all select '百度') a
select CAST(item AS VARCHAR) from
(select CAST('abc' AS VARBINARY(8000)) item
union select CAST('Abc' AS VARBINARY(8000))
union select CAST('百度' AS VARBINARY(8000))
) a
select distinct(item) from
(select 'abc' COLLATE CHINESE_PRC_BIN item
union select 'Abc'
union select N'百度') a
select distinct(item) from
(select 'abc' COLLATE CHINESE_PRC_CS_AS item
union select 'Abc'
union select N'百度') a
select distinct(item) from
(select 'abc' COLLATE CHINESE_PRC_CS_AS item
union select 'Abc'
union select '百度') a