注册 登录
编程论坛 MySQL论坛

[求助]怎样解决中文在页面上显示乱码的问题?

hahajune 发布于 2006-04-16 14:46, 1533 次点击
数据库内正常显示,用查询语句在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;"
%>
1 回复
#2
dreame2006-04-23 22:54
编码问题吧!!mysql中好象是用utf-8类型的!页面用gb2312看看!!
1