| Author |
Message
|
| ivan8008 |
 Posted: Thu Nov 23, 2006 3:36 am Post subject: cyrillic in ESQL code |
 |
|
Novice
Joined: 26 Oct 2006
Posts: 17
Location: Sofia, Bulgaria
|
Hi,
Does somebody know how can I initialize variables in cyrillic in my ESQL code?
I tried to do so but the cyrillic appears like '??????' in the message.
Please help
_________________
Ivan Tumbev
MQ Series Administrator & Broker Developer
ICQ 344974669
ivan_tumbev@yahoo.com |
|
| Back to top |
|
 |
| Edde |
| Posted: Thu Nov 23, 2006 6:04 am Post subject: |
|
|
Acolyte
Joined: 01 Oct 2006
Posts: 67
Location: Moscow, Russia
|
On what OS are you running?
You have cyrillic names or values? |
|
| Back to top |
|
|
| ivan8008 |
| Posted: Thu Nov 23, 2006 8:02 am Post subject: HI |
|
|
Novice
Joined: 26 Oct 2006
Posts: 17
Location: Sofia, Bulgaria
|
I am using Windows 2003 Enterprise edition, but the regional settings are English US.
I want to initialize values in cyrillic. (to hardcode them), because they are not comming with the input message and are constants
_________________
Ivan Tumbev
MQ Series Administrator & Broker Developer
ICQ 344974669
ivan_tumbev@yahoo.com |
|
| Back to top |
|
|
| gorjy |
| Posted: Thu Nov 23, 2006 11:48 am Post subject: Re: |
|
|
Novice
Joined: 15 Jul 2005
Posts: 18
Location: Bulgaria, Sofia
|
Get to this posting. It is not for cyrillic, but maybe it can help.
Go down about half of the page. There is a piece of code posted by TonyD.
I think there maybe a way to create new variables with cyrillic value by casting them with a specified CCSID. |
|
| Back to top |
|
|
| Edde |
| Posted: Fri Nov 24, 2006 12:02 am Post subject: Re: |
|
|
Acolyte
Joined: 01 Oct 2006
Posts: 67
Location: Moscow, Russia
|
gorjy
Your link points to wrong thread, smth about XML namespaces.
Please correct.
ivan8008
We had have many problems with cyrillic characters in ESQL until we set regional settings to Russian (Bulgarian in your case).
But you can also take a look at:
1. Do you have correct cyrillic characters in .cmf file?
You can try to set Regional settings on the computer with Toolkit.
2. Do you set OutputRoot.MQMD.CodedCharSetId correctly in your message flow?
3. What are hex values of '??????' in output message? What tool are you using to see this message? |
|
| Back to top |
|
|
| gorjy |
| Posted: Fri Nov 24, 2006 1:46 am Post subject: Re: |
|
|
Novice
Joined: 15 Jul 2005
Posts: 18
Location: Bulgaria, Sofia
|
Edde
My idea was to create a variable, with a certain CCSID, to hold the text which will be inserted into the message. |
|
| Back to top |
|
|
| ivan8008 |
| Posted: Fri Nov 24, 2006 5:52 am Post subject: hi |
|
|
Novice
Joined: 26 Oct 2006
Posts: 17
Location: Sofia, Bulgaria
|
well I try to deal with the problem without setting the regional settings to bulgarian because in that way the DB2 generates errors - maybe needs additional settings
I tried to initialize a blob environment in hex and to cast it to char, but i couldn't code the cyrillic! the broker interprets 2 bytes per simbol, but I can code cyrillic with 4 bytes... so when i code 4 bytes in hex i get two latin characters instead of one cyrillic
can you recommend wich CCSID to use?
_________________
Ivan Tumbev
MQ Series Administrator & Broker Developer
ICQ 344974669
ivan_tumbev@yahoo.com |
|
| Back to top |
|
|
| Edde |
| Posted: Fri Nov 24, 2006 6:35 am Post subject: Re: hi |
|
|
Acolyte
Joined: 01 Oct 2006
Posts: 67
Location: Moscow, Russia
|
| ivan8008 wrote: |
well I try to deal with the problem without setting the regional settings to bulgarian because in that way the DB2 generates errors - maybe needs additional settings
I tried to initialize a blob environment in hex and to cast it to char, but i couldn't code the cyrillic! the broker interprets 2 bytes per simbol, but I can code cyrillic with 4 bytes... so when i code 4 bytes in hex i get two latin characters instead of one cyrillic
can you recommend wich CCSID to use? |
It looks like Bulgarian uses the same character set as Russian - 1251 (Windows Cyrillic).
But if you want to use UTF-8, it's CCSID 1208.
If your output format is XML, UTF-8 is preferable. |
|
| Back to top |
|
|
| ivan8008 |
| Posted: Sun Nov 26, 2006 11:31 pm Post subject: hi |
|
|
Novice
Joined: 26 Oct 2006
Posts: 17
Location: Sofia, Bulgaria
|
unfortunately it doesn't work.
_________________
Ivan Tumbev
MQ Series Administrator & Broker Developer
ICQ 344974669
ivan_tumbev@yahoo.com |
|
| Back to top |
|
|
| Edde |
| Posted: Sun Nov 26, 2006 11:57 pm Post subject: |
|
|
Acolyte
Joined: 01 Oct 2006
Posts: 67
Location: Moscow, Russia
|
| Please post ESQL code with CAST that doesn't work and output message. |
|
| Back to top |
|
|
|
|
