modify your db 's collationand add N' before your sql field and modify char to nchar
不是char的问题collate在哪里修改?
修改数据库的排序规则: select distinct collationid from dbo.syscolumns select * from dbo.syscolumns where collationid=53251 --Chinese_Taiwan_Stroke_CI_AS select * from dbo.syscolumns where collationid=53284 --Chinese_PRC_CI_AS
EXEC sp_configure 'allow updates',1 RECONFIGURE WITH OVERRIDE
update dbo.syscolumns set collationid=53284 where collationid=53251
EXEC sp_configure 'allow updates',0 RECONFIGURE WITH OVERRIDE go
select * from dbo.syscolumns where collationid=53251 --Chinese_Taiwan_Stroke_CI_AS
select * from dbo.syscolumns where collationid=53284 --Chinese_PRC_CI_AS
EXEC sp_configure 'allow updates',1 RECONFIGURE WITH OVERRIDE
update dbo.syscolumns set collationid=53284 where collationid=53251
EXEC sp_configure 'allow updates',0 RECONFIGURE WITH OVERRIDE
go