[求助]怎样解决中文在页面上显示乱码的问题?
数据库内正常显示,用查询语句在DOS中也能正常地显示中文、数字和英语字母,但是在ASP网页中,却不能正常显示中文,中文成了????符号,数字和字母正常。请指点(windows下asp+mysql5.0+myodbc)。现数据库设置如下:
Variable_name | Value |
+--------------------------+-------------------------------------------+
| character_set_client |gb2312
| character_set_connection | gb2312
| character_set_database | gb2312
| character_set_results | gb2312
| character_set_server | gb2312
| character_set_system | utf8 |
| character_sets_dir | D:\MySQL\MySQL Server 5.0\share\charsets\ |
ASP显示页面代码设置如下:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/conncet.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_conncet_STRING
Recordset1.Source = "SELECT * FROM test.super"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
数据库实验连接代码:
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_conncet_STRING
MM_conncet_STRING = "dsn=myodbc;"
%>