大家帮看看,数据库查询不能查找到中文内容
数据库链接:
conn_string = "Provider=OraOLEDB.Oracle.1;Password=******;Persist Security Info=False;User ID=******;Data Source=******"
'conn_string = "Provider=MSDAORA.1;Password=******;Persist Security Info=False;User ID=******;Data Source=******"
Set Conn = server.CreateObject("ADODB.Connection")
Conn.Open conn_string
数据库查询:
sqlSearch1 = "Select * from User where status = 0 "
sqlSearch1 = sqlSearch1 & " and ( empno like '%" & Keyword &"%' or name like UPPER('%" & Keyword & "%') or engname like UPPER('%" & Keyword & "%')) "
sqlSearch1 = sqlSearch1 & " order by empno asc"
Set rsSearch1=Server.CreateObject("Adodb.RecordSet")
rsSearch1.open sqlSearch1,Conn,1,1
=====================================================================
1、数据库是ORACLE8.1.7
2、使用的OraOLEDB,而不是MSDAORA(此不能rs.addnew等操作)
3、查询的时候可以查询英文、数字等,唯独不能查询中文,查询字段类型是nvarchar2;
??????