GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

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%';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center