MQSeries.net :: View topic - How to find the correct codepage?

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 » How to find the correct codepage?

How to find the correct codepage?

« View previous topic :: View next topic »

Author

Message

busy_chap

Posted: Wed Aug 18, 2010 12:46 pm Post subject: How to find the correct codepage?

Acolyte

Joined: 18 May 2006
Posts: 69

Hi,
I know that the database collation for one of our databases is Polish_100_CI_AS. SO how do I find out what is the corresponding code page for this so that I can use this in WBI to handle the double byte Polish characters.

I googled but nothing was helpful. Any pointers would be greatly appreciated.
Thanks in advance.

Vitor

Posted: Wed Aug 18, 2010 12:56 pm Post subject: Re: How to find the correct codepage?

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

busy_chap wrote:

I googled but nothing was helpful.

This didn't seem entirely unhelpful.

Unicode is also a solid choice for all your character needs, and indeed is used by WMB internally so this question is only valid for input & output.
_________________
Honesty is the best policy.
Insanity is the best defence.

busy_chap

Posted: Wed Aug 18, 2010 1:09 pm Post subject:

Acolyte

Joined: 18 May 2006
Posts: 69

Thanks for your super quick response. I appreciate it.
Yes I did see that. We built message flows for another European country and we used 1252 to handle data properly but when I use 1252 for Polish , it's only passing 2 or 3 of the Polish chars to the output so I thought the best approach would be to find out the code page setting on the database on Poland's end.

But all I know is the collation of the database and I tried to match this with the code page by googling but could not find a link.

But looks like what you are saying is.. if the data is handled or routed to the output queue correctly meaning all polish chars to the output q.. the data would be loaded fine to the database?

I will try with 1250 and see what happens.

busy_chap

Posted: Tue Aug 24, 2010 7:49 pm Post subject:

Acolyte

Joined: 18 May 2006
Posts: 69

Thanks Vitor. My issue is resolved. i used codepage 1208 and all the Polish characters were handled fine.
I appreciate your help.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to find the correct codepage?

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