--你在写匹配的时候注意英文中文的区别就行啦: select * from mytable where Bus collate Chinese_PRC_CS_AS_WS like '%,%' //英文逗号
--例子: select * from ( select id=1,Bus='abc,aa' --半角, union all select 2,'ab,aa' --全角, union all select 3,'addb,dre' --全角, union all select 4,'aasb,asd,fasd' --半角, union all select 5,'ab,ds' --全角, ) a where Bus collate Chinese_PRC_CS_AS_WS like '%,%' --半角,
--例子: select * from ( select id=1,Bus='abc,aa' --半角, union all select 2,'ab,aa' --全角, union all select 3,'addb,dre' --全角, union all select 4,'aasb,asd,fasd' --半角, union all select 5,'ab,ds' --全角, ) a where Bus collate Chinese_PRC_CS_AS_WS like '%,%' --半角,
1.collate
2.Windows 排序规则名称
select * from mytable where Bus collate Chinese_PRC_CS_AS_WS like '%,%' //英文逗号
select * from (
select id=1,Bus='abc,aa' --半角,
union all select 2,'ab,aa' --全角,
union all select 3,'addb,dre' --全角,
union all select 4,'aasb,asd,fasd' --半角,
union all select 5,'ab,ds' --全角,
) a
where Bus collate Chinese_PRC_CS_AS_WS like '%,%' --半角,
select * from (
select id=1,Bus='abc,aa' --半角,
union all select 2,'ab,aa' --全角,
union all select 3,'addb,dre' --全角,
union all select 4,'aasb,asd,fasd' --半角,
union all select 5,'ab,ds' --全角,
) a
where Bus collate Chinese_PRC_CS_AS_WS like '%,%' --半角,