请教oracle数据迁移到mysql的问题

显示全部楼层 · 2012-12-21 14:48:20

需求：将oracle的表导入mysql
oracle版本：10.2.0.1
mysql版本：5.6.20
我通过MySQL Migration Toolkit进行数据迁移，表结构成功导入MySQL，但是在导数据的时候报错：
`yqjk`.`fllb_cjlb`
------------------

Incorrect string value: '\xA2\xDC1\xA2\xDCi...' for column 'cslb' at row 1

0 row(s) transfered.
`yqjk`.`gzlb_gzlc`
------------------

Incorrect string value: '\xC8\xA1\xC4\xDA\xC8\xDD' for column 'qqxx' at row 2186

0 row(s) transfered.
`yqjk`.`gzlb_gzzz`
------------------

Incorrect string value: '\xB7\xA2\xB1\xED\xD3\xDA...' for column 'gzlr' at row 1

Incorrect string value: '\xCF\xC2\xD2\xBB\xD2\xB3' for column 'gzlr' at row 3

Incorrect string value: '\xB7\xA2\xCC\xFB\xCA\xB1...' for column 'gzlr' at row 8

Incorrect string value: '\xCF\xC2\xD2\xBB\xD2\xB3' for column 'gzlr' at row 2

0 row(s) transfered.
我查了一下网上的案例，应该是字符集问题。
oracle字符集如下
SQL> select * from nls_database_parameters;
PARAMETER
VALUE
------------------------------ --------------------------------------------------------------------------------
NLS_LANGUAGE
AMERICAN
NLS_TERRITORY
AMERICA
NLS_CURRENCY
$
NLS_ISO_CURRENCY
AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET
ZHS16GBK
NLS_CALENDAR
GREGORIAN
NLS_DATE_FORMAT
DD-MON-RR
NLS_DATE_LANGUAGE
AMERICAN
NLS_SORT
BINARY
NLS_TIME_FORMAT
HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMATDD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY
$
NLS_COMP
BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP
FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION
10.2.0.1.0
MySQL字符集如下：
mysql> show variables like 'char%';
+--------------------------+----------------------------+
| Variable_name
| Value
|
+--------------------------+----------------------------+
| character_set_client | utf8
|
| character_set_connection | utf8
|
| character_set_database | latin1
|
| character_set_filesystem | binary
|
| character_set_results| utf8
|
| character_set_server | latin1
|
| character_set_system | utf8
|
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
已尝试更改下面参数:
set names gbk;
SET GLOBAL character_set_server=gbk;
SET GLOBAL character_set_database=gbk;
ALTER TABLE table_name DEFAULT CHARSET utf8;
仍然报错，求指导，谢谢！