Why do some fields get truncated by adb subscriber when we use adb.encoding as latin_1 for database with character set WE8ISO8859P1? The OS is Linux and the ADB version is 5.2.1.

Why do some fields get truncated by adb subscriber when we use adb.encoding as latin_1 for database with character set WE8ISO8859P1? The OS is Linux and the ADB version is 5.2.1.

book

Article ID: KB0090958

calendar_today

Updated On:

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

Description

Resolution:
This issue happens on Linux boxes when adb.encoding is set to LATIN_1 (i.e. ISO8859-1 on design time list) and the database character set is WE8ISO8859P1.

When subscriber tries to insert the received data to the target table, some fields get truncated.

This issue can be resolved by applying the ADB 5.2.1 hotfix 9.

ADB 5.2.2 also does not have this issue.


KEYWORDS: WE8ISO8859P1, TRUNCATED, LATIN_1, ENCODING, LINUX, ADB SUBSCRIBER.

Issue/Introduction

Why do some fields get truncated by adb subscriber when we use adb.encoding as latin_1 for database with character set WE8ISO8859P1? The OS is Linux and the ADB version is 5.2.1.