数据库读乱码

[jingzhefei521]

Select * from Wenti Where shifoujiejue = '" + " 否" + "' and Wentiyue='"+timess+"' Order by shifou desc 这是存到数据库里的，在数据库里都正常

Select * from Wenti Where shifoujiejue ='\"+\"是\" +\"'and Wentiyue='\"+timess+\"' Order by shifou desc 读出来就变成这个样子


怎么解决

[ws_hgo]

unicode编码问题
把varchar修改未navcahr()
或者在字符串前面加上N
select * from tb where [name]=N'胡'

[xiashifei]

绑定

[xiashifei]

帮顶，人家是\ 你N什么呀， 又从网上抄的

[LemIST]

写段代码处理下就好了

[dawnbear]

这个问题应该是数据库取出来的""问题了，自己过滤去 我说你那个 '"+"否"+"' 能不能写成 '否' 啊？ 不是一样么 你写的很怪异

[zzxap]

string a=@"Select * from Wenti Where shifoujiejue = '" + " 否" + "' and Wentiyue='"+timess+"' Order by shifou desc "