| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Unconvertable character and Informix |
« View previous topic :: View next topic » |
| Author |
Message
|
| Gama |
 Posted: Fri Jan 18, 2008 12:56 am Post subject: Unconvertable character and Informix |
 |
|
Centurion
Joined: 11 Jan 2005
Posts: 103
Location: Portugal
|
Hello all,
When i make the simple select above i return the 'Unconvertable character', on the table field have 'Serv. Técn. SA'
I'm using WMB6006 on WinXp and Informix 7.2.1.
That's the error.
ExceptionList
0x01000000:Insert =
0x03000000:Type = 5
0x03000000:Text = 'SAFT.SAFT_PT_CARREGAMENTO_COMUM_get_Header.Main'
0x01000000:Insert =
0x03000000:Type = 5
0x03000000:Text = '25.3'
0x01000000:Insert =
0x03000000:Type = 5
0x03000000:Text = 'SET Environment.Variables.Dados.Header = DEFAULTPASSTHRU'select t_ncmp, t_net, t_nama from ttccom000200';'
0x01000000:RecoverableException =
0x03000000:File = 'F:\build\S600_P\src\CommonServices\ImbConverter.cpp'
0x03000000:Line = 516
0x03000000:Function = 'ImbConverterCPP::internalToUnicode'
0x03000000:Type = ''
0x03000000:Name = ''
0x03000000:Label = ''
0x03000000:Catalog = 'BIPv600'
0x03000000:Severity = 3
0x03000000:Number = 2135
0x03000000:Text = 'Unconvertable character'
0x01000000:Insert =
0x03000000:Type = 5
0x03000000:Text = 'e3'
0x01000000:Insert =
0x03000000:Type = 5
0x03000000:Text = '4c532d47657374e36f20456d70726573617269616c206520496d6f622e2c2053412e20'
0x01000000:Insert =
0x03000000:Type = 2
0x03000000:Text = '1208'
Exist any parameter to include on ODBC connection that convert's the character or the problem looks like ccsid's???
Thanks
Gama |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Fri Jan 18, 2008 4:20 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Could it be that on of the bytes being sent is outside the char limits (like padding with hex 00)?
I have a hard time thinking of a true local character that cannot be converted to unicode 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Jan 18, 2008 4:43 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| fjb_saper wrote: |
| I have a hard time thinking of a true local character that cannot be converted to unicode |
Any character in a local codepage for which there is not a conversion table to Unicode available. This implies nothing about whether there is a conversion possible... just that there isn't a table found.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Gama |
| Posted: Fri Jan 18, 2008 6:37 am Post subject: |
|
|
Centurion
Joined: 11 Jan 2005
Posts: 103
Location: Portugal
|
Thanks jefflowrey and fjb_saper, for your's answers, but where can i configure the convertion table?
My database is Informix 7.2 and i'm connecting with ODBC 3.82 32Bit.
The contents of my table is the following:
t_ncmp t_net t_nama
230 geral@xxxx.pt Transp. Reun.
240 geral@xxxx.pt Lus. Seg
250 geral@xxxxx.pt SO. Técn
260 Gestão Imo.
The two first's records "230 as 240" return's ok and the "250 and 260" return "Unconvertable Characters".
Regards |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
