非常急!!在线关注(oracle乱码问题)
oracle8.0.5
下面是程序代码,请各位高手帮忙看一下,谢谢!
<%
dim sqlstr
dim feereason
dim reasons
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.DbOpenDatabase("kjc","scott/tiger",1)
sqlstr="select * from ITEM_FEE where ITEM_NUMBER='"&session("selrecord")&"'"
set rs=OraDatabase.DbCreateDynaset(sqlstr,0)
do while not rs.eof
feereason="lkjhklghfghf"
rs.dbEdit
rs("FEE_REASON")=feereason
rs.dbUpdate
rs.movenext
loop
response.write "<p align=center><font color=blue>数据已更改!</font></p>"
Set OraSession = nothing
'说明:为了方便,我只把主要的部份列出,无论变量feereason是什么值,数据库里都是乱
码
'其中FEE_REASON为字段名
%>
如果改用update语句更改数据,数据库内就不会出现乱码问题。问什么?