Products | Versions |
---|---|
TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
Not Applicable | - |
Resolution:
Description:
============
How to handle the € (Euro sign) with Oracle databse character setting WINDOWS-1252 (NLS_CHARACTERSET WE8MSWIN1252).
Environment:
==========
Al
Oracle Database
ADB6.0.0
Resolution:
==========
To handle the € (Euro sign) with Oracle databse character setting WINDOWS-1252 (NLS_CHARACTERSET WE8MSWIN1252), please set adb.encoding to IBM-5348 and project message encoding to UTF8.
From within Designer:
1). Go to Designer project root folder -> Project Settings and select IBM-5348 as TIBCO Messaging Encoding
2). Go to adapter instance configuration, select "Show all Tabs", go to "General" tab, update the value of adb.encoding to UTF8
In runtime, add adb.encoding IBM-5348 to the *.tra file.
On UNIX platforms, add IANAAppCodePage=2252 ( WINDOWS-1252) in the odbc.ini file. On Windows, enable N-CHAR support.