如何让sqlserver对查询字符串大小写敏感
select * from tableName where name like '%c%'
要选出只包括小写c的name
如何实现？
---------------------------------------------------------------
CREATE TABLE [Table7] (
[string] [varchar] (50) COLLATE Chinese_PRC_CI_AI NULL ,
[curdate] [datetime] NOT NULL CONSTRAINT [DF_Table7_curdate] DEFAULT (getdate())
) ON [PRIMARY]
GO
insert table7(string,curdate) values( 'a12' , '2002-08-27 17:21:05.140' )
insert table7(string,curdate) values( 'A21' , '2002-08-27 17:21:07.433' )
insert table7(string,curdate) values( 'aaa' , '2002-08-27 17:21:18.097' )
insert table7(string,curdate) values( 'Asss' , '2002-08-27 17:21:23.917' )
insert table7(string,curdate) values( 'sAs' , '2002-08-27 17:21:26.140' )
insert table7(string,curdate) values( 'aaaaaq' , '2002-08-27 17:21:28.240' )
insert table7(string,curdate) values( 'xxxa' , '2002-08-27 17:21:32.307' )
insert table7(string,curdate) values( '121A' , '2002-09-05 14:34:11.910' )
go
SELECT *
FROM Table7
string curdate
-------------------------------------------------- ------------------------------------------------------
a12 2002-08-27 17:21:05.140
A21 2002-08-27 17:21:07.433
aaa 2002-08-27 17:21:18.097
Asss 2002-08-27 17:21:23.917
sAs 2002-08-27 17:21:26.140
aaaaaq 2002-08-27 17:21:28.240
xxxa 2002-08-27 17:21:32.307
121A 2002-09-05 14:34:11.910
(8 row(s) affected)
--字符集是Chinese_PRC_CI_AI，大小写不敏感
SELECT *
FROM Table7
WHERE (string LIKE '%a%')
string curdate
-
------------------------------------------------- ------------------------------------------------------
a12 2002-08-27 17:21:05.140
A21 2002-08-27 17:21:07.433
aaa 2002-08-27 17:21:18.097
Asss 2002-08-27 17:21:23.917
sAs 2002-08-27 17:21:26.140
aaaaaq 2002-08-27 17:21:28.240
xxxa 2002-08-27 17:21:32.307
121A 2002-09-05 14:34:11.910
(8 row(s) affected)
--改变字符集
alter table table7 ALTER COLUMN string varchar(50) COLLATE Chinese_PRC_CS_AI
go
--字符集是Chinese_PRC_CS_AI，大小写敏感
SELECT *
版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。
发表评论