- ALTER TABLE `cdb_ai` DEFAULT CHARACTER SET big5 COLLATE big5_chinese_ci;
- ALTER TABLE `cdb_bighome` DEFAULT CHARACTER SET big5 COLLATE big5_chinese_ci;
- ALTER TABLE `cdb_client` DEFAULT CHARACTER SET big5 COLLATE big5_chinese_ci;
- ALTER TABLE `cdb_gupiaoconfig` DEFAULT CHARACTER SET big5 COLLATE big5_chinese_ci;
- ALTER TABLE `cdb_personalstock` DEFAULT CHARACTER SET big5 COLLATE big5_chinese_ci;
- ALTER TABLE `cdb_rndevent` DEFAULT CHARACTER SET big5 COLLATE big5_chinese_ci;
- ALTER TABLE `cdb_stock` DEFAULT CHARACTER SET big5 COLLATE big5_chinese_ci;
- ALTER TABLE `cdb_stocknews` DEFAULT CHARACTER SET big5 COLLATE big5_chinese_ci;
复制代码- ALTER TABLE `cdb_ai` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
- ALTER TABLE `cdb_bighome` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
- ALTER TABLE `cdb_client` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
- ALTER TABLE `cdb_gupiaoconfig` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
- ALTER TABLE `cdb_personalstock` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
- ALTER TABLE `cdb_rndevent` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
- ALTER TABLE `cdb_stock` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
- ALTER TABLE `cdb_stocknews` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
复制代码- ALTER TABLE `cdb_ai` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `cdb_bighome` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `cdb_client` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `cdb_gupiaoconfig` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `cdb_personalstock` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `cdb_rndevent` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `cdb_stock` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `cdb_stocknews` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
复制代码 以上用過了都還是出現- Discuz! info: MySQL Query Error
- User: 寒風
- Time: 2008-7-19 9:41pm
- Script: /good2/plugin.php
- SQL: select ynlock,money,nowbuy,nowsell,id,allmoney,style from [Table]client where acc='寒風'
- Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (big5_chinese_ci,COERCIBLE) for operation '='
- Errno.: 1267
- Similar error report has beed dispatched to administrator before.
复制代码 我的論壇是6.0 BIG5
用的版本
V2.5 build 1565(20070901)
[ 本帖最后由 asadman152 于 2008-7-19 21:43 编辑 ] |