€ (Euro sign) can not be processed successfully inTIBCO ActiveMatrix® Adapter for Database 6.0.0.

€ (Euro sign) can not be processed successfully inTIBCO ActiveMatrix® Adapter for Database 6.0.0.

book

Article ID: KB0086117

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database -
Not Applicable -

Description

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.

Issue/Introduction

€ (Euro sign) can not be processed successfully inTIBCO ActiveMatrix® Adapter for Database 6.0.0.