create table test (a varchar(100))
go
insert test values('aabb')
go
select * from Test where a collate chinese_prc_CS_Ai ='AaBb'
select * from test where a='AaBb'
create database mmm
go
use mmm
go
ALTER DATABASE mmm COLLATE Latin1_General_Ci_Ai
go
create table test (a nvarchar(100))
go
insert test values(N'大力')
go
select * from test where a=N'大力'
select * from test where a='大力' --这句是错的。