MQSeries.net :: View topic - retrieve double-byte chars from database

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » retrieve double-byte chars from database

retrieve double-byte chars from database

« View previous topic :: View next topic »

Author

Message

george_king

Posted: Tue Apr 26, 2005 6:01 am Post subject: retrieve double-byte chars from database

Newbie

Joined: 17 Mar 2005
Posts: 6

I have lines of code to retrieve data from sybase through ODBC in MB. The Data include double-bytes char. I have set Charset of Sybase as utf8. But the output message is not correct. I'v done following things:

1. set sybase to utf8
2. set CSSID as 1381 ( MQ guide said it is for windows )
3. set encoding as 546

The Double-Byte char I hardcode in ESQL could be output to message correct.

Could someone help me?

malammik

Posted: Tue Apr 26, 2005 7:51 am Post subject:

Partisan

Joined: 27 Jan 2005
Posts: 397
Location: Philadelphia, PA

What's the data type of the records in Sybase? Sometimes just chaging the db to another ccsid does not change how certain data types store data particularly in the context of existing records.

I would try to maybe retrieve data as blob then use one of the bitstream functions to convert to 1208 and then back to char.
_________________
Mikhail Malamud
http://www.netflexity.com
http://groups.google.com/group/qflex

george_king

Posted: Wed Apr 27, 2005 7:39 am Post subject:

Newbie

Joined: 17 Mar 2005
Posts: 6

The data type is char(20). It is not perfect way to retrieve it as blob then convert it. It means we have to know which field might be double-bytes...

malammik

Posted: Wed Apr 27, 2005 9:24 am Post subject:

Partisan

Joined: 27 Jan 2005
Posts: 397
Location: Philadelphia, PA

I see your point and I agree with it. I would still try to do the I described above to test and make sure that sybase indeed stores the data in utf8.
_________________
Mikhail Malamud
http://www.netflexity.com
http://groups.google.com/group/qflex

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » retrieve double-byte chars from database

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP