DB2 Connect Character Conversion Issue

Scott

I am using DB2 Connect on HP-UX 11i to read data from an AS400 using
SQL. DB2 Connect is converting a vertical bar (¦) character to this:
ª. Please see the example below. I have tried changing the user ID's
CCSID to 037 and this did not correct the problem. Any suggestions
would be greatly apprecated. Thanks.

Data as it appears on the 400:

150 KENNEDY DRIVE¦

Data when queried through DB2 Connect:

150 KENNEDY DRIVEª

One application developer offered this theory:
"That would be an erroneous translation. The vertical bar character
is a 7-bit ASCII character, code 124. It should not be translated
into a 16-bit character. It looks like there is an error in the
EDCIDIC to ASCII translation."

However, I am not sure how to stop DB2 Connect from converting this
incorrectly.

Nov 12 '05 #1

Subscribe Post Reply

5011

Anton Versteeg

Something must be wrong:

| is indeed ASCII x'7C'
The character you are showing is a ¦ (broken bar) which is X'A6' in
ASCII and X'00A6' in UTF-16
Perhaps you can do a select hex(column) from table ?
Scott wrote:

I am using DB2 Connect on HP-UX 11i to read data from an AS400 using
SQL. DB2 Connect is converting a vertical bar (¦) character to this:
ª. Please see the example below. I have tried changing the user ID's
CCSID to 037 and this did not correct the problem. Any suggestions
would be greatly apprecated. Thanks.

Data as it appears on the 400:

150 KENNEDY DRIVE¦

Data when queried through DB2 Connect:

150 KENNEDY DRIVEª

One application developer offered this theory:
"That would be an erroneous translation. The vertical bar character
is a 7-bit ASCII character, code 124. It should not be translated
into a 16-bit character. It looks like there is an error in the
EDCIDIC to ASCII translation."

However, I am not sure how to stop DB2 Connect from converting this
incorrectly.

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

Nov 12 '05 #2

Karl Hanson

Anton Versteeg wrote:

Something must be wrong:

| is indeed ASCII x'7C'
The character you are showing is a ¦ (broken bar) which is X'A6' in
ASCII and X'00A6' in UTF-16
Perhaps you can do a select hex(column) from table ?

Scott wrote:
I am using DB2 Connect on HP-UX 11i to read data from an AS400 using
SQL. DB2 Connect is converting a vertical bar (¦) character to this:
ª. Please see the example below. I have tried changing the user ID's
CCSID to 037 and this did not correct the problem. Any suggestions
would be greatly apprecated. Thanks.

Data as it appears on the 400:

150 KENNEDY DRIVE¦

Data when queried through DB2 Connect:

150 KENNEDY DRIVEª

One application developer offered this theory:
"That would be an erroneous translation. The vertical bar character
is a 7-bit ASCII character, code 124. It should not be translated
into a 16-bit character. It looks like there is an error in the
EDCIDIC to ASCII translation."

However, I am not sure how to stop DB2 Connect from converting this
incorrectly.

If you submit a problem report, you could use the ddcstrc utility to get
a DRDA trace. This shows the datastream exchanged between DB2 Connect
and the AS/400. See Problem Determination in the DB2 Connect User's
Guide here (sorry for long URL):
http://www.ibm.com/cgi-bin/db2www/da...7c0frm3toc.htm

--
Karl Hanson

Nov 12 '05 #3

Sherman Lau

Anton is correct. There are two similiar characters in CCSID 37. One is
Vertical Bar x4F and the other one is Broken Veritical Bar x6A in CCSID 37.
The character you are using is x6A in CCSID 37. This character is not
defined in HP environment. In order to save the letter we mapped the broken
vertical bar to character 'ª' on HP.

Sherman

"Anton Versteeg" <an************@nnll.iibbmm.com> wrote in message
news:40**************@nnll.iibbmm.com...

Something must be wrong:

| is indeed ASCII x'7C'
The character you are showing is a ¦ (broken bar) which is X'A6' in
ASCII and X'00A6' in UTF-16
Perhaps you can do a select hex(column) from table ?
Scott wrote:
I am using DB2 Connect on HP-UX 11i to read data from an AS400 using
SQL. DB2 Connect is converting a vertical bar (¦) character to this:
ª. Please see the example below. I have tried changing the user ID's
CCSID to 037 and this did not correct the problem. Any suggestions
would be greatly apprecated. Thanks.

Data as it appears on the 400:

150 KENNEDY DRIVE¦

Data when queried through DB2 Connect:

150 KENNEDY DRIVEª

One application developer offered this theory:
"That would be an erroneous translation. The vertical bar character
is a 7-bit ASCII character, code 124. It should not be translated
into a 16-bit character. It looks like there is an error in the
EDCIDIC to ASCII translation."

However, I am not sure how to stop DB2 Connect from converting this
incorrectly.

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

Nov 12 '05 #4

Similar topics

xml, character encoding, asp question

by: Mark | last post by:

Hi... I've been doing a lot of work both creating and consuming web services, and I notice there seems to be a discontinuity between a number of the different cogs in the wheel centering around...

ASP / Active Server Pages

Any foreign character mapping charts available?

by: jmev7 | last post by:

I'm in the US, and have to constantly take data input from other countries. Some of this data has characters which I can't understand, since it's input from other language keyboards. This prevents...

Microsoft Access / VBA

Test for contiguous alphabet in character set

by: Stefan Krah | last post by:

Hello, I am currently writing code where it is convenient to convert char to int . The conversion function relies on a character set with contiguous alphabets. int set_mesg(Key *key, char...

C / C++

Problems with Replace Method

by: james | last post by:

Hi, I am loading a CSV file ( Comma Seperated Value) into a Richtext box. I have a routine that splits the data up when it hits the "," and then copies the results into a listbox. The data also...

Visual Basic .NET

Character Constants

by: Akhil | last post by:

Since a character constant is an int value represented as a character in single quotes,so it is treated as a 1 byte integer now look at the following snippet. #include<stdio.h> int main(void)...

C / C++

wide character (unicode) and multi-byte character

by: =?Utf-8?B?R2Vvcmdl?= | last post by:

Hello everyone, Wide character and multi-byte character are two popular encoding schemes on Windows. And wide character is using unicode encoding scheme. But each time I feel confused when...

.NET Framework

Get ASCII value for character when higher than 127

by: ssetz | last post by:

Hello, For work, I need to write a password filter. The problem is that my C+ + experience is only some practice in school, 10 years ago. I now develop in C# which is completely different to me....

C / C++

MessageBox(...) only displays first character of input string

by: sovht | last post by:

System: Intel, Windows XP Pro, SP2 IDE: VC++ 6.0 Problem: *Very* simple program to create a MessageBox only ever displays the first character of the given string. I checked the spec for the...

C / C++

ASP.Net-C#: "Conversion failed... character string to uniqueidentifier"

by: blazeboy | last post by:

Hello, I am using a SQL data source to insert records into a table. The table uses a GUID as the primary key (GoalEventID), and a GUID for a second field (GoalID) as a foreign key. When I call...

.NET Framework

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA