get junk char with gg, sync from oracle to mysql 5.5
edited Apr 17, 2013 5:41AM in GoldenGate, Streams and Distributed Database (MOSC) 22 commentsAnswered ✓
Hi all,
I met the situation, configure gg to sync data from oracle 10.2.0.4 to mysql 5.5. the configuration works, the problem get junk chars. our table contain chinese chars, it displays junk chars in the mysql:
mysql> select * from GE_BILL_ADDRESS where id=1 \G
*************************** 1. row ***************************
ID: 1
CREATED_TIME: 2012-06-26 11:32:40
CREATOR_ID: 4766
DOMAIN_ID: 2
LOCK_VERSION: 0
UPDATED_TIME: 2013-04-07 10:04:17
UPDATOR_ID: NULL
RE_MARK: NULL
UDF1: NULL
UDF2: NULL
UDF3: NULL
UDF4: NULL
UDF5: NULL
UDF6: NULL
UDF7: NULL
UDF8: NULL
BILL_CODE: NULL
PROVINCE: 鐎瑰绐
CITY: NULL
COUNTY: NULL
ADDRESS: 閸濆牆鐨靛銊ョ闁鏂傜悰
DESTINATION: NULL
LNG: 0.000000
LAT: 0.000000
1 row in set (7.36 sec)
mysql> show variables like '%character%';
0