How to convert the character data to IBM-1251

How to convert the character data to IBM-1251

book

Article ID: KB0081069

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database 7.x

Description


i)The ActiveMatrix Database Adapter 7.x is JAVA based SDK so JVM internally operates with data in Unicode Format and all data transferred into or out of the JVM is in a format matching to the file.Use the encoding Java property(java.property.file.encoding in the adbagent.tra file).

ii) Files that are in the integrated file system are tagged with a "coded character set identifier (CCSID)" that identifies the character encoding of the data contained in the file of System and data from the DB2 database converts to the CCSID of the System totally through the JDBC APIs. 

iii)The TIBCO JDBC drivers(DD) supported by ADB 7.x provides the connection parameter "CharsetFor65535" which specifies the code page to be used by the driver to convert character data that is stored as bit data in character columns (Char, Varchar, Longvarchar, Char for Bit Data, Varchar for Bit Data, Longvarchar for Bit Data) defined with CCSID 65535. All character data that is stored as bit data and returned from the database using columns defined with CCSID 65535 is converted using the specified code page. 
By default, the driver automatically determines which code page to use to convert Character data. Use this property only if you need to change the driver’s default behavior.

iv)The code page of CCSID 1251 (MS-WIN CYRILLIC) maps as CP1251.

Issue/Introduction

Conversion of published data from one encoding format(e.g ccsid 37) to another encoding format(e.g IBM-1251) for IBM DB2 database.

Environment

Product: TIBCO ActiveMatrix Adapter for Database Version: All supported 7.x versions OS: All Supported Operating Systems Database:IBM DB2 for Linux, Unix and Windows 9.5.x, 9.7.x, 9.8.x,10.0.x, 10.1.x, 10.5.x

Resolution

To convert the character data to IBM-1251 (Cyrillics) for the publication adapter after the migration to AcitveMatrix Database Adapter 7.x from 6.x follow the below steps:
-  java.property.file.encoding=(CP1251)the encoding format that is set during publishing the message in the .tra file
-  CharsetFor65535=CP1251 in the JDBC URL of the design-time&run-time Connection of the adapter instance configuration
-  Like for CharsetFor65535=CP1251 JDBC connection property, add CodePageOverride=CP1251 to override the code page which is used by the JDBC driver to determine which code page to use for the conversion.
e.g jdbc:tibcosoftwareinc:db2://<servername>:50000;databaseName=<databaseName;packageName=DEF00;CharsetFor65535=CP1251;CodePageOverride=CP1251