SQL Server插入中文数据出现乱码问题

2020-04-07

一般来说,如果含有中文字符,用nchar/nvarchar,如果纯英文和数字,用char/varchar;如果依旧无效,再字符串前加一个N就可以避免中文乱码的问题

insert into promary values(1,N'北京市') 
insert into promary values(2,N'天津市') 
insert into promary values(3,N'上海市') 
insert into promary values(4,N'重庆市') 
insert into promary values(5,N'河北省') 
insert into promary values(6,N'山西省') 
insert into promary values(7,N'台湾省') 
insert into promary values(8,N'辽宁省') 
insert into promary values(9,N'吉林省') 
insert into promary values(10,N'黑龙江省') 
insert into promary values(11,N'江苏省')
{/if}