IC SunsetThe developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this community and its apps will no longer be available. More details available on our FAQ.
  • 1 reply
  • Latest Post - ‏2010-07-19T12:16:32Z by luis_ventura
228 Posts

Pinned topic Problem with EURO € Simbol in IDS 11.10.0000 FC2.

‏2009-08-18T16:08:53Z |
I migrate from Informix 7 to IDS 11.10.0000 FC2.

When i try to insert o show (old data) with characters special,
example €,italian caracters, we receive a run time error:

Run time error '40002':
S100:InformixInformix ODBC DriverUnspecified System Error =

We store data in diferents languages Spanish, Portuguese,
English,Italian, German and French.
ODBC : IBM Informix ODBC Driver Setup Utility 3.00.0000 3.00.TC3
IDS :11.10.0000 FC2.
Clients :Windows XP access to server using ODBC ->DSN

What i need to do?

Any help will be aprecciated.

Updated on 2010-07-19T12:16:32Z at 2010-07-19T12:16:32Z by luis_ventura
  • luis_ventura
    1 Post

    Re: Problem with EURO € Simbol in IDS 11.10.0000 FC2.

    Hello Abelardo:

    I suffered a similar problem with € symbol.

    We changed the Connect Version in our clients, and the € symbol started to cause the -21005 error. As far as I know, the problem is not on the server side, but on the client Side (or at least, in the character conversion between server locale and client locale). Open a session from the client and execute a onstat -g env for this session. You should search for the DB_LOCALE, CLIENT_LOCALE and SERVER_LOCALE and post them here. Maybe this would help us to get a solution.

    Best Regards.