这是我总结的一些解决方案,不知对LZ有帮助没
1: 安装MySQL数据库时候就指定字符集合为gbk或者gb2312,只要数据库中显示正常中文字符的话,页面肯定显示正常,哪来这么多的转换,烦死了!!
2: 指定服务器的 编码 GBK 或者GB23123: 修改安装目录下的 初始化配置文件 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
1: 安装MySQL数据库时候就指定字符集合为gbk或者gb2312,只要数据库中显示正常中文字符的话,页面肯定显示正常,哪来这么多的转换,烦死了!!
2: 指定服务器的 编码 GBK 或者GB23123: 修改安装目录下的 初始化配置文件 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
解决方案 »
- 设置mysqld的默认字符集,出错[谢谢]
- 关于数据库连接的问题
- 询问关于discuz数据库设计的问题,为什么它的时间不用timestamp而是int,是非的值也不用boolean而是tinyint(1)
- 求条件查询排序优化方法
- 请问调用mysql函数,是带引号好,还是不带引号好
- Mysql连接问题!
- 请问各位大虾怎样在ems mysql manager 3 lite中对数据库进行备份?谢谢
- 求助:谁有用PHP+MySQL写的论坛的原码?
- SLAVE服务器里的表不存在?……
- Mysql 语句执行顺序疑问
- 请教:我在windows中用什么工具来操作msql?
- 请教:linux下连接mysql的问题
BSTR bstrSQL = strSql.AllocSysString();
m_pRecordset->Open(bstrSQL,(IDispatch*)m_pConnection,adOpenDynamic,adLockOptimistic,adCmdText); strSql="select * from vehicle";
bstrSQL = strSql.AllocSysString();
m_pRecordset->Open(bstrSQL,(IDispatch*)m_pConnection,adOpenDynamic,adLockOptimistic,adCmdText);