急求，在线等，用asp操作oracle给表里添数据为什么出来的全是问号

[glassch]

<!--#include file=../conn.asp-->
<%
smallclass1=request("smallclass")
sql="select * from bigclass2 order by id"
set rs=oradatabase.dbcreatedynaset(sql,0)
totalPut=rs.RecordCount
do while not rs.eof
sql1="select * from bigclass"
set rs1=oradatabase.dbcreatedynaset(sql1,0)
if rs("bigclass")&""<>"" then
rs1.addnew
rs1("class")=rs("class")
rs1("bigclass")=rs("bigclass")
rs1("bm")=rs("bm")
rs1.update
end if
rs.movenext
loop
%>

[dinya2003]

应该是字符集的问题.看一下本地注册表中的oracle键下的nls_lang键值. 改成以下查询得到的结果:

select tab1.aa||'_'||tab2.bb||'.'||tab3.cc from (select VALUE$ aa from sys.props$ where name='NLS_LANGUAGE')tab1,(select VALUE$ bb from sys.props$ where name='NLS_ISO_CURRENCY')tab2,(select VALUE$ cc from sys.props$ where name='NLS_CHARACTERSET')tab3

[zonelive]

请参考：
http://community.csdn.net/Expert/FAQ/FAQ_Index.asp?id=139572