CREATE DATABASE `bbs1` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
成功,
但是到了导入的时候:
mysql -uroot -p --default-character-set=gbk -f bbs1<test.sql
结果出现一堆错误:
类似:
ERROR 1062 (23000) at line 3928: Duplicate entry '????' for key 2
ERROR 1062 (23000) at line 3932: Duplicate entry '????' for key 2
ERROR 1062 (23000) at line 3935: Duplicate entry '??¡Á?' for key 2
ERROR 1062 (23000) at line 3939: Duplicate entry '???¡ã' for key 2
ERROR 1062 (23000) at line 3943: Duplicate entry '??¡Á?' for key 2
ERROR 1062 (23000) at line 3954: Duplicate entry '??????¡À¨´' for key 2
ERROR 1062 (23000) at line 3970: Duplicate entry '????????' for key 2
ERROR 1062 (23000) at line 3983: Duplicate entry '????????' for key 2
ERROR 1062 (23000) at line 3989: Duplicate entry '??¡Á?' for key 2
ERROR 1062 (23000) at line 3993: Duplicate entry '???¡ì' for key 2
ERROR 1062 (23000) at line 3997: Duplicate entry '??????' for key 2
ERROR 1062 (23000) at line 4010: Duplicate entry '??????' for key 2
ERROR 1062 (23000) at line 4012: Duplicate entry '????' for key 2
ERROR 1062 (23000) at line 4016: Duplicate entry '????' for key 2
ERROR 1062 (23000) at line 4059: Duplicate entry '????' for key 2
ERROR 1062 (23000) at line 4067: Duplicate entry '????' for key 2
ERROR 1062 (23000) at line 4135: Duplicate entry '????' for key 2
ERROR 1062 (23000) at line 4148: Duplicate entry '????' for key 2
ERROR 1062 (23000) at line 4162: Duplicate entry '????' for key 2