工程类型:asp.net
编程语言:basic
在向sql server中插入中文字段时总显示为:??
把数据库中的字段设置成nvarchar后仍然显示为??
注意到原插入语句为:strSQL = "Insert into message(userid,email,IP,content,senddate)Values('" & Session("userid") & "','" & Email.Text & "','" & Request.UserHostAddress & "','" & Content.Text & "','" & System.DateTime.Now & "')"
这里Content.Text字段总显示为??,于是改为:strSQL = "Insert into message(userid,email,IP,content,senddate)Values('" & Session("userid") & "','" & Email.Text & "','" & Request.UserHostAddress & "',N'" & Content.Text & "','" & System.DateTime.Now & "')"
这样就可以将中文正常的存入数据库了!!