Source: AS400 DB2 6.1
Target: AS400 DB2 6.1
The field type is Character, but not Character-o, content contains Chinese Chracters
Optim directory db and db which hosts remote table from source db are both UTF-8. Extract, convert, Insert can be processed. But browsing extracted file, Chinese characters shows as unreadable codes。 And in AS400, the inserted Chinese Chracters shows as block diagram
Optim directory db and db which hosts remote table from source db are both GBK, Extract, convert can be processed, browsing extracted file, Chinese characters shows as expected. BUT, the extracted files cannot be inserted into Target table
ICU error converting from Multibyte into Unicode (as UChar) using db2luw-1386, reason 12 = U_ILLEGAL_CHAR_FOUND
This topic has been locked.
3 replies Latest Post - 2012-12-26T13:27:00Z by sbjerry
Pinned topic Problem when processing data in DB2 of AS400
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-12-26T13:27:00Z at 2012-12-26T13:27:00Z by sbjerry
Re: Problem when processing data in DB2 of AS4002012-12-26T03:16:36Z in response to sbjerryAnother question is that, when the optim directory db and db hosts remote table are both 1386, and source and target db on AS400, when insert, why it convert 1386 to Unicode?