username列是gbk编码.
asp页面
connstrbbs = "driver={mysql odbc 3.51 driver};server=127.0.0.1;uid=root;pwd=*;database=bbs"
SET Conn=Server.CreateObject("ADODB.Connection")
Conn.Open connstrbbs
sql="select id from mem where w='社区飞扬'"
SET RecSetObj=Conn.Execute(sql)============================
报错
Microsoft OLE DB Provider for ODBC Drivers (0x80040E31)
[MySQL][ODBC 3.51 Driver][mysqld-4.1.18-nt]Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
是不是页面编码问题..
asp页面
connstrbbs = "driver={mysql odbc 3.51 driver};server=127.0.0.1;uid=root;pwd=*;database=bbs"
SET Conn=Server.CreateObject("ADODB.Connection")
Conn.Open connstrbbs
sql="select id from mem where w='社区飞扬'"
SET RecSetObj=Conn.Execute(sql)============================
报错
Microsoft OLE DB Provider for ODBC Drivers (0x80040E31)
[MySQL][ODBC 3.51 Driver][mysqld-4.1.18-nt]Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
是不是页面编码问题..
解决方案 »
- 咨询一下,用VS2010连接MYSQL的时候报错(找不到请求的.net framework data provider。可能没有安装)
- FROM_UNIXTIME 问题
- 数据库缓存问题
- postgresql两数相除保留小数两位?
- mysql里是否有将varchar或char 转换为 int的函数!
- select * from 表名 into outfile 是不是不能备份远程数据库?
- 请教关于Mysql C API 中类型MYSQL_ROW 和printf函数的用法
- MYSQL数据库读写求助
- 一个数据库中有两种存储引擎 myisam innodb
- 小白问个数据库表的问题,希望大神帮忙
- 帮帮小弟吧 mysql远程连接问题
- 求解一条优化的select
sql="select id from mem where username='社区飞扬'"
根据提示,'='两边的编码不同你是不是整个数据库的编码方式是latin1_swedish_ci?
我查汉字的时候也会出现这种问题,也还没解决,帮你顶。
我是用c++写的,user_name LIKE _gb2312 '一洋' COLLATE gb2312_chinese_ci
| Charset | Description | Default collation | Maxlen |
+----------+-----------------------------+---------------------+--------+
| big5 | Big5 Traditional Chinese | big5_chinese_ci | 2 |
| dec8 | DEC West European | dec8_swedish_ci | 1 |
| cp850 | DOS West European | cp850_general_ci | 1 |
| hp8 | HP West European | hp8_english_ci | 1 |
| koi8r | KOI8-R Relcom Russian | koi8r_general_ci | 1 |
| latin1 | cp1252 West European | latin1_swedish_ci | 1 |
| latin2 | ISO 8859-2 Central European | latin2_general_ci | 1 |
| swe7 | 7bit Swedish | swe7_swedish_ci | 1 |
| ascii | US ASCII | ascii_general_ci | 1 |
| ujis | EUC-JP Japanese | ujis_japanese_ci | 3 |
| sjis | Shift-JIS Japanese | sjis_japanese_ci | 2 |
| hebrew | ISO 8859-8 Hebrew | hebrew_general_ci | 1 |
| tis620 | TIS620 Thai | tis620_thai_ci | 1 |
| euckr | EUC-KR Korean | euckr_korean_ci | 2 |
| koi8u | KOI8-U Ukrainian | koi8u_general_ci | 1 |
| gb2312 | GB2312 Simplified Chinese | gb2312_chinese_ci | 2 |
| greek | ISO 8859-7 Greek | greek_general_ci | 1 |
| cp1250 | Windows Central European | cp1250_general_ci | 1 |
| gbk | GBK Simplified Chinese | gbk_chinese_ci | 2 |
| latin5 | ISO 8859-9 Turkish | latin5_turkish_ci | 1 |