mysql administrator 中配置了默认字符集gb2321,表中涉及中文的列也是gb2321,在mysql administrator能正确显示中文,关闭数据库再打开也是正常,但输出到vb,用debug.print 显示乱码,输出到list控件也是乱码,怎么搞啊?
顺便还提个问题,难道mysql仅支持 rs.Fields(6).Value ,而不支持 rs.Fields(“列名”).Value的表达式,我再vb中用后者老师报错!
顺便还提个问题,难道mysql仅支持 rs.Fields(6).Value ,而不支持 rs.Fields(“列名”).Value的表达式,我再vb中用后者老师报错!
解决方案 »
- 急!运行问题!
- 把结果集中相同类型数据显示三条。
- sql语句,求答???
- 如何附加数据库文件夹
- 再次提问,求一SQL,没想到mysql的高手如云啊,开源软件多有魅力
- 启动PostgreSQL时,为什么会出现“在本地计算机 无法启动PostgreSQL服务。服务并未返回错误。这可能是一个windows内部错误或服务内部错误
- 关于mysql用户帐号权限的问题
- PostgreSQL user defined function 错误排出,谢谢
- 求MySql多表插入的写法。。。
- Android点餐系统的错误,登陆不上去
- PGSQL 视图 FULL JOIN 可以有多少?
- 用VB连接mysql ,myodbc3.51也安装并配置好,但是报错 unknown database 'myodbc'
connstr = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=127.0.0.1;port=3306;DATABASE=test;UID=root;PWD=root;OPTION=3"
'打开连接
conn.Open connstr
sql = "select * from dian1"
Set rs = conn.Execute(sql)
While Not rs.EOF
Debug.Print rs.Fields(6).Value
Debug.Print rs.Fields("填表人")
rs.MoveNext
Wend
在哪里设置字串字符集?
Debug.Print rs.Fields
这句报错!# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]port=3306[mysql]default-character-set=gb2321
# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]# 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="C:/Program Files/MySQL/MySQL Server 5.0/"#Path to the database root
datadir="C:/Program Files/MySQL/MySQL Server 5.0/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=gb2312