KEY (Id ) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='测试表'; 以上就是Illegal mix of collations (latin1_swedish_ci
NOT NULL AUTO_INCREMENT COMMENT '前台id' , `d_name` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci...NULL DEFAULT NULL COMMENT '姓名' , `d_password` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci...NULL DEFAULT NULL COMMENT '顾客编号' , `g_name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci...NULL DEFAULT NULL COMMENT '姓名' , `g_sex` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci...NULL DEFAULT NULL COMMENT 'room位置' , `r_state` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci
Traditional Chinese | big5_chinese_ci | 2 | | dec8 | DEC West European | dec8_swedish_ci...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...例如，latin1默认校对规则是latin1_swedish_ci。
+———————-+——————-+ | Variable_name | Value | +———————-+——————-+ | collation_connection | latin1_swedish_ci...| | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | +———————-+—
的字符集为 latin1 -- cp1252 West European 此字符集将会在生成查询语句包含中文的时候报如下错误 异常信息 Illegal mix of collations (latin1_swedish_ci...operation '='MySql.Data.MySqlClient.MySqlException (0x80004005): Illegal mix of collations (latin1_swedish_ci...operation '=' ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Illegal mix of collations (latin1_swedish_ci
cp866_general_ci 1 cp932 SJIS for Windows Japanese cp932_japanese_ci 2 8-Dec DEC West European dec8_swedish_ci...Russian koi8r_general_ci 1 koi8u KOI8-U Ukrainian koi8u_general_ci 1 latin1 cp1252 West European latin1_swedish_ci...macroman Mac West European macroman_general_ci 1 sjis Shift-JIS Japanese sjis_japanese_ci 2 swe7 7bit Swedish...swe7_swedish_ci 1 tis620 TIS620 Thai tis620_thai_ci 1 ucs2 UCS-2 Unicode ucs2_general_ci 2 ujis EUC-JP
Traditional Chinese | big5_chinese_ci | 2 | | dec8 | DEC West European | dec8_swedish_ci...Russian | koi8r_general_ci | 1 | | latin1 | cp1252 West European | latin1_swedish_ci...| 1 | | big5_bin | big5 | 84 | | Yes | 1 | | dec8_swedish_ci
( `id` int(11) NOT NULL AUTO_INCREMENT , `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci...NULL DEFAULT NULL , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci...NULL DEFAULT NULL , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci...` int(11) NOT NULL AUTO_INCREMENT , `permission` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci...NULL DEFAULT NULL , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
`student_id` int(11) NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci...DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci...DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci
-+-------------------+ | collation_connection | utf8_general_ci | | collation_database | latin1_swedish_ci...| | collation_server | latin1_swedish_ci | +----------------------+-------------------+ 3）show variables...| NULL | | select,insert,update,references | | | mac_id | char(17) | 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
': 波特语, 'portuguese': 葡萄牙语, 'romanian': 罗马尼亚语, 'russian': 俄语, 'spanish': 西班牙语, 'swedish...german', 'hungarian', 'italian', 'norwegian', 'porter', 'portuguese', 'romanian', 'russian', 'spanish', 'swedish
Chinese | big5_chinese_ci | 2 | | dec8 | DEC West European | dec8_swedish_ci...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...Charset Description Default collation Maxlen latin1 cp1252 West European latin1_swedish_ci...| 8 | | utf8_spanish_ci | utf8 | 199 | | Yes | 8 | | utf8_swedish_ci
japanese_ci 日语, 不区分大小写 dec8 (DEC West European) dec8_bin 西欧 (多语言), 二进制 dec8_swedish_ci...不区分大小写 latin1_german2_ci 德语 (电话本), 不区分大小写 latin1_spanish_ci 西班牙语, 不区分大小写 latin1_swedish_ci...Shift-JIS Japanese) sjis_bin 日语, 二进制 sjis_japanese_ci 日语, 不区分大小写 swe7 (7bit Swedish...) swe7_bin 瑞典语, 二进制 swe7_swedish_ci 瑞典语, 不区分大小写 tis620 (TIS620 Thai) tis620...斯洛文尼亚语, 不区分大小写 ucs2_spanish2_ci 传统西班牙语, 不区分大小写 ucs2_spanish_ci 西班牙语, 不区分大小写 ucs2_swedish_ci
Dutch dmy 8 Norsk Norwegian dmy 9 Português Portuguese dmy 10 Suomi Finnish dmy 11 Svenska Swedish...AdventureWorks2008; ------------顯示各國語言的星期幾（2000，2005，2008版本支持）Geovin Du 塗聚文注 --顯示語言周幾 SET LANGUAGE swedish
Traditional Chinese | big5_chinese_ci | 2 | | dec8 | DEC West European | dec8_swedish_ci...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...-----------------+---------------------+--------+ | latin1 | cp1252 West European | latin1_swedish_ci
Japanese | cp932_japanese_ci | 2 | | dec8 | DEC West European | dec8_swedish_ci...| koi8u_general_ci | 1 | | latin1 | cp1252 West European | latin1_swedish_ci...1 | | sjis | Shift-JIS Japanese | sjis_japanese_ci | 2 | | swe7 | 7bit Swedish...| swe7_swedish_ci | 1 | | tis620 | TIS620 Thai | tis620...dec8_bin | dec8 | 69 | | Yes | 1 | PAD SPACE | | dec8_swedish_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...chinese_ci big5 1 Yes Yes 1 big5_bin big5 84 Yes 1 dec8_swedish_ci...1 | | latin2 | ISO 8859-2 Central European | latin2_general_ci | 1 | | swe7 | 7bit Swedish
| Value | +----------------------+-------------------+ | collation_connection | latin1_swedish_ci...| | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | +-------
NO_ENGINE_SUBSTITUTION comment: character_set_client: latin1 collation_connection: latin1_swedish_ci...db_collation: latin1_swedish_ci body_utf8: begin select ename into out_ename from...50 | NULL | NULL | NULL | latin1 | latin1_swedish_ci
-+-------------------+ | collation_connection | utf8_general_ci | | collation_database | latin1_swedish_ci...| | collation_server | latin1_swedish_ci | +----------------------+-------------------+ 修改字符集： sudo
领取专属 10元无门槛券
手把手带您无忧上云
云服务器
ICP备案
对象存储
即时通信 IM
实时音视频
