为什么把TextBox中的数据[汉字]插入到SQL Server中后变成了'??'?[通宵在线等待]

[TrojanSckiss]

我把TextBox中的数据成功的插入到了SQL Server中,但是打开SQL Server数据库发现其中是???,我不明白是怎么一回事情,请大家指教.我的代码象下面这个样子:
===================================================================

Dim FormsAuthortication As System.Web.Security.FormsAuthentication
Dim Nname as string
Nname=TextBoxNickName.Text
Dim HashCode as string
HashCode=FormsAuthentication.HashPasswordForStoringInConfigFile(TextBoxPasswd.Text,"MD5")
Dim Protect as string
Protect=TextBoxQuestion.Text
Dim ProAnswer as string
ProAnswer=TextBoxAnswer.Text
Dim RealName as string
RealName=TextBoxRealName.Text
Dim Email as string
Email=TextBoxEmail.Text
Dim Age as string
Age=TextBoxAge.Text
Dim Sex as string
Sex=DropDownListSex.SelectedValue
Dim Address as string
Address=TextBoxAddress.Text
Dim Phone as string
Phone=TextBoxPhone.Text
Dim Describe as String
Describe=TextBoxDescription.Text

Dim SqlString As String = "server=LANXIN;database=miniSkirt;trusted_connection=true"
Dim SqlStr As String = "INSERT INTO Tab_User(NickName,HashCode,ProtectQuestion,ProtectAnswer,RealName,LinkEmail,Age,Sex,Address,LinkPhone,Description,DateTime,IsActive,IsLocked,IsDeleted) VALUES ("
SqlStr=SqlStr & "'" & Nname.Replace("'","''") & "',"
SqlStr=SqlStr & "'" & HashCode.Replace("'","''") & "',"
SqlStr=SqlStr & "'" & Protect.Replace("'","''") & "',"
SqlStr=SqlStr & "'" & ProAnswer.Replace("'","''") & "',"
SqlStr=SqlStr & "'" & RealName.Replace("'","''") & "',"
SqlStr=SqlStr & "'" & Email.Replace("'","''") & "',"
SqlStr=SqlStr & "'" & Age.Replace("'","''") & "',"
SqlStr=SqlStr & "'" & Sex.Replace("'","''") & "',"
SqlStr=SqlStr & "'" & Address.Replace("'","''") & "',"
SqlStr=SqlStr & "'" & Phone.Replace("'","''") & "',"
SqlStr=SqlStr & "'" & Describe.Replace("'","''") & "',"
SqlStr=SqlStr & "'" & DateTime.Now.ToString() & "',"
SqlStr=SqlStr & "'" & "0" & "',"
SqlStr=SqlStr & "'" & "1" & "',"
SqlStr=SqlStr & "'" & "1" & "')"
Dim SqlConnection As New SqlConnection(SqlString)
Dim SqlCommand As New SqlCommand(SqlStr, SqlConnection)
SqlConnection.Open()
SqlCommand.ExecuteNonQuery()
SqlConnection.Close()
response.Redirect("WaitActive.aspx")
End sub

[webserv2]

修改web.config内容如下：
<globalization
requestEncoding="utf-8"
responseEncoding="utf-8"
/>

为：
<globalization
requestEncoding="gb2312"
responseEncoding="gb2312"
/>

即可！

[saucer]

what is the datatype are you using in your database? try nchar or nvarchar

also, what is the encoding in globalization in your web.config?

[TrojanSckiss]

我查看了SQL Server的和UNICODE文档,证明不是Sql Server问题,问题是出在webserv2(GIS)(CAU)指示的错误,而且我在这里找到了这个帖子:
http://community.csdn.net/Expert/topic/3703/3703533.xml?temp=.2264063
webserv2(GIS)(CAU),saucer(思归,非常感谢你们~,你们对我的帮助很大,谢谢,我要怎么才能给你们分数.

[webserv2]

呵呵！点上面的帖子 标题 边上的 管理 即可进入揭贴界面 操作 哈哈

[lxw99]

修改web.config内容如下：
<globalization
requestEncoding="utf-8"
responseEncoding="utf-8"
/>

为：
<globalization
requestEncoding="gb2312"
responseEncoding="gb2312"
/>

即可！
如果不改成gb2312问题会有很多，例如调用js都会出错

[vzxq]

nod