试一下: declare @a table (a varchar(10)) insert @a select 'Abc' union all select 'aBc' union all select 'aBC'select * from @a select * from @a where a='aBc' collate Chinese_prc_CS_AI
SELECT text FROM logon WHERE name = 'aBc' collate chinese_prc_CS_AI是这样吗? 好像不行!我的数据库是Access做的
可能在ACCESS 数据库里设置就可以,在以下
select * from T where cast(field as varbinary) = cast('AaBb' as varbinary)
SELECT Description FROM Categories WHERE CONTAINS(Name, ' "AcBd" ') and (name = 'AcBd')
可以的。
declare @a table (a varchar(10))
insert @a select 'Abc'
union all select 'aBc'
union all select 'aBC'select * from @a select * from @a where a='aBc' collate Chinese_prc_CS_AI
好像不行!我的数据库是Access做的
from T
where cast(field as varbinary) = cast('AaBb' as varbinary)
FROM Categories
WHERE CONTAINS(Name, ' "AcBd" ') and (name = 'AcBd')