This documentation is for an older version of HVR.

How to Specify Encoding for Binary Field

Question

For translating DB2 for i binary columns (CCSID encoded) to MSSQL varchar, I tried to set up a ColumnProperties action to translate binary fields from DB2 for i that are stored as binary encoded text (CCSID 37, US English) through the following configuration which is partially successful:

/DatatypeMatch=binary /Datatype=varchar /Length=bytelen

However, the text encoding is missed and the target characters do not match the source. How can I specify an encoding for a binary field at the source, or for translation during Integrate?

Environment

HVR 5

Answer

On the source, set environment variable HVR_DB_CHARSET_BITDATA with a value of IBM037.

Specify encoding

After this action is added, the channel should be initialized with the Scripts and Jobs option enabled.