ASP MySQL appears the question mark garbled solution _ Application Skill

So the problem is because

Database character set, table character set, field character set is set to: Gbk_chinese_ci


Note the database connection string inside the Stmt=set Names ' GBK ', must have this sentence.


The following is the ASP link MySQL code. Please note that there is a GBK at the back. This is the encoding type that specifies the link. According to the data you use
The library encoding type. Modify it into your own.

ConnectionString = "Driver={mysql ODBC 3.51
Driver}; Server=myserver;database=mysql; user=myuser;password=mypassword;option=3; Stmt=set
Names ' GBK '

If you use a high version of MySQL, often in such cases, Chinese often garbled, including in PHP.

Method of Reference:


Set the font for MySQL.
Join in Mysql.ini

[MySQL]
default-character-set=gb2312

[Client]
default-character-set=gb2312

[Mysqld]
default-character-set=gb2312//or GBK

After the registration has changed, the database before the change has no effect. The contents of the Db.opt file in these database directories are changed to

default-character-set=gb2312
Default-collation=gb2312_chinese_ci

You can do that.



Dim Drivername,chs
Drivername= "Driver={mysql ODBC 3.51
driver};server=localhost;database=test;uid=loaer;pwd=123456; "
Set Conn=server.createobject ("Adodb.connection")
Conn.Open drivername


' Before querying, execute the following sentence first
Set Chs=conn. Execute ("SET NAMES ' gb2312 '")

' Querying database tables

sql = "SELECT * FROM Tb_commondata"
Set RS = conn. Execute (SQL)


So it's not garbled.