Home Topics HVR Real-time Replicator Community Discussions DB2 for i binary columns (CCSID encoded) to MSSQL varchar
I have tried to setup a ColumnProperties action to translate binary fields from DB2 for i that are stored as binary encoded text (CCSID 37, US English). The following configuration is partially successful:
/DatatypeMatch=binary /Datatype=varchar /Length=bytelen
Unfortunately the text encoding is missed and the target characters do not match our source. How do you specify an encoding for a binary field at the source, or for translation during integrate?
Assuming you are on a recent version of HVR then you should set the following environment variable on the source: HVR_DB_CHARSET_BITDATA, with a value of “IBM037”
I recommend you do this through an action Environment.
Hope this helps.
That worked, thank you.
© 2020 HVR
It appears you are still using Internet Explorer. Support for IE has been discontinued by Microsoft, and many features of our site may not display or work properly.
Please upgrade (it's free!) to Edge, Chrome, Safari, or any modern browser for the best user experience.