asp中使用ajax传中文值插入sql2000乱码问题
永恒的微笑 2010-06-23 10:09:18 这个是我的页面处理代码:
<!-- #include file ="../inc/conn.asp" -->
<%
dim webSiteName,webSiteUrl,webSiteNum,webSiteAgeLimit ,webSiteLogo,webSiteState
webSiteName = request("webSiteName")
webSiteUrl = request("webSiteUrl")
webSiteNum = request("webSiteNum")
webSiteAgeLimit = request("webSiteAgeLimit")
webSiteLogo = request("webSiteLogo")
webSiteState = request("webSiteState")
OpenDB
set cmd = server.CreateObject("ADoDB.Command")
cmd.ActiveConnection = oConn
cmd.CommandText = "proNewWebSite"
cmd.CommandType = 4
cmd.Prepared = true
with cmd
.Parameters.Append .CreateParameter("@webSiteName",200,1,50,webSiteName)
.Parameters.Append .CreateParameter("@webSiteUrl",200,1,255,webSiteUrl)
.Parameters.Append .CreateParameter("@webSiteNum",200,1,50,webSiteNum)
.Parameters.Append .CreateParameter("@webSiteAgeLimit",3,1,4,webSiteAgeLimit)
.Parameters.Append .CreateParameter("@webSiteLogo",200,1,50,webSiteLogo)
.Parameters.Append .CreateParameter("@webSiteState",3,1,4,webSiteState)
.execute
End With
if err then
response.Write("创建失败!原因:"&err.description)
CloseDB
response.End()
end if
set cmd.ActiveConnection = nothing
set cmd = nothing
response.Write("ok")
CloseDB
%>
比如webSiteName 从页面ajax传的值是中文,在处理页面打印测试中文字符没出现乱码。但是在插入数据库中后,数据中的中文就变成乱码了。页面编码用的是utf-8。找了很久都没找到问题的所在?请各位高手帮忙看下