sql server中文乱码解决

1）修改varchar为nvarchar

alter table yourtable alter column  yourcolumn  nvarchar(200)

2）修改数据库的collate

select name,collation_name from sys.databases
where name='yourdatabase'

alter database yourdatabase set single_user with rollback immediate;
alter database yourdatabase collate Chinese_PRC_CI_AS;
alter database yourdatabase set multi_user;