使用UCS2时mysql的编码问题

Question

我正在尝试导入一个大的csv文件编码的UCS2-大印度到mysql表。

下面是mysql代码：

DROP TABLE if exists PAPERS; 

CREATE TABLE `PAPERS` (
ID_RESEARCHER VARCHAR(20),
PAPER_ACCESSOR_NUMBER VARCHAR(20),
  primary key(ID_RESEARCHER,PAPER_ACCESSOR_NUMBER)
) ENGINE=InnoDB DEFAULT CHARSET=ucs2;

load data local infile '...dump_all_papers_test_2.csv' 
into table PAPERS
CHARACTER SET ucs2
fields terminated by '\t' enclosed by '"'
lines terminated by '\n' 
(ID_RESEARCHER, PAPER_ACCESSOR_NUMBER);

和csv (格式ucs-2大印度，由notepad++说)的内容)

"100"   "A1974U626600001"
"100"   "A1974U626600001"
"100"   "A1974U626600001"

csv示例的副本：

http://pastebin.com/HMssuxCf

错误是：

1 row(s) affected, 2 warning(s):
1265 Data truncated for column 'ID_RESEARCHER' at row 1
1261 Row 1 doesn't contain data for all columns
Records: 1  Deleted: 0  Skipped: 0  Warnings: 2

这是怎么回事？

该操作仅填充第一个字段。mysql不支持ucs2吗？

Answer 1

好的。

文档中提供了解决方案：

请注意，当前无法加载使用ucs2字符集的数据文件。

http://dev.mysql.com/doc/refman/5.0/en/load-data.html