Datastage JDBC Connector Chinese garbled processing

In DataStage, it is customary to encode the Chinese characters by setting the three-level NLS at the project, JOB, stage

However, the JDBC Connector stage component does not have the NLS option, but rather passes through the "Properties" tab inside the stage.

"Session"--"Character set for Non-unicode columns"-"Character set name *"

By default, "Character set for Non-unicode columns" is set to default, using the Utf-8 character set,

In the Chinese environment, it needs to be set to "Custom", and the sub-option "Character Set name *" is set to the Chinese character set supported by the system, usually using GB18030 for the best support for medium character.

This article is from the "Fighting" blog, make sure to keep this source http://lewapi.blog.51cto.com/3030129/1941342

Datastage JDBC Connector Chinese garbled processing