一/网上找的教程ASP连接MYSQL的东东
<%
strconnection = "dsn=mysqldsn;"
set adodataconn = server.createobject("adodb.connection")
adodataconn.open strconnection
strquery = "select * from b__wz_article"
set rs = adodataconn.execute(strquery)
if not rs.bof then
do while not rs.eof response.write rs("title") & "<br>"
rs.movenext
loop else
response.write("sorry, no data found.")
end if
rs.close
adodataconn.close
set rs = nothing
set adodataconn = nothing
%> 已经成功了,可以输出,但是输出的为乱码!
二/以下为编码设置
mysql> show variables like '%char%';
+--------------------------+----------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | D:\Program Files\MySQL\share\charsets\ |
+--------------------------+----------------------------------------+
8 rows in set (0.00 sec)三/MYSQL数据库字段编码为GBK问题:怎样解决输出时的编码问题!
<%
strconnection = "dsn=mysqldsn;"
set adodataconn = server.createobject("adodb.connection")
adodataconn.open strconnection
strquery = "select * from b__wz_article"
set rs = adodataconn.execute(strquery)
if not rs.bof then
do while not rs.eof response.write rs("title") & "<br>"
rs.movenext
loop else
response.write("sorry, no data found.")
end if
rs.close
adodataconn.close
set rs = nothing
set adodataconn = nothing
%> 已经成功了,可以输出,但是输出的为乱码!
二/以下为编码设置
mysql> show variables like '%char%';
+--------------------------+----------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | D:\Program Files\MySQL\share\charsets\ |
+--------------------------+----------------------------------------+
8 rows in set (0.00 sec)三/MYSQL数据库字段编码为GBK问题:怎样解决输出时的编码问题!
解决方案 »
- 请求各位高人,postgreSQL 中 to_number()函数用法
- 急,高手帮帮忙看看一个sql
- mysql的event有执行日志么??
- 4千万数据的表,删除重复数据
- mysql中,外键约束的问题~~在线等答案~~^_^
- 在线80分求救,mysql修改unique索引出错
- 在mysql 5.0 里直接输入数据时 都是?号,请问怎么解决?
- 请问谁有数据库维护策略的模板(java+mysql)
- mysql 时间触发器
- 你们好!我用navicat里面的命令窗口输入? contents 无法显示帮助内容
- ASP 通过 ODBC 连 MySQL,的编码问题
- SQL Server附加的Visual Studio 2005没有编程语言,怎么办?
修改安装目录下的 初始化配置文件 my.ini# The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir="E:/MySQL5/"
#Path to the database root
datadir="E:/MySQL5/Data/"# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1 换成 gbk 或者 gb2312# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB客户端建立Connection后立即执行sql:SET NAMES gb2312
然后在该Connection下执行其他操作 比如插入数据 就没有乱码问题了Connect;
ExecuteSql("SET NAMES gb2312");
insert("...");
update..
select ..
..Close;