IDS Forum

Re: AW: CSDK 2.90 / 3.00 / 3.50 and EURO sign

Posted By: Gerald Cousins
Date: Thursday, 5 February 2009, at 1:44 p.m.

In Response To: AW: CSDK 2.90 / 3.00 / 3.50 and EURO sign (Jörg Volz)

Hi Joerg,

This might be a good test to add to your suite,

This just makes sure that code set conversion is happening
correctly for the environment that you are running in.

If you have problems please let me know

As,

The code point for euro on Windows is 0x80.

The code point for euro in 8859-15 is 0xa4.
And

you are running on windows with DB_LOCALE and CLIENT_LOCALE =
de_de.8859-15
we should check that the code point "0xA4" was actually inserted into the
database.

You mentioned that a version of IDS is running on linix,

If you have access to an X environment Id set
LC_ALL=de_DE.iso885915@euro (or the 8859-15 equivalent) before running a
terminal (most terminals will detect this setting and use it for
displaying characters)

If you are using a terminal emulator ensure that it is configured
to use 8859-15.

In this terminal set CLIENT_LOCALE=de_de.8859-15.
For windows,

CLIENT_LOCALE should be de_de.cp1252
In both environments (all environments that connect to the database) set
DB_LOCALE=de_de.8859-15

If you run the statement in both the unix and windows environments,

insert into tab values ("€");
You should get the same character inserted to the database (0xa4)

If you then run (in both environments)

select col from tab where col = "€");
You should see 2 rows returned in both environments, In the linux
environment "0xa4" will be returned and in windows environment "0x80" will
be returned for both rows.

Gerry.

From:
"Jörg Volz" <Joerg@it-volz.de>
To:
ids@iiug.org
Date:
02/05/2009 10:02 AM
Subject:
AW: CSDK 2.90 / 3.00 / 3.50 and EURO sign [14764]

Hy and thanks for the hint.

de_DE.8859-15 as DB and Client locale did the job very fine.

Thank you very much.

regards,
Joerg

"Center, negative on the traffic. I see only a flock of birds."
"Well, look closer. One of them has a transponder."

________________________________

Von: ids-bounces@iiug.org im Auftrag von Gerald Cousins
Gesendet: Mi 28.01.2009 05:31
An: ids@iiug.org
Betreff: Re: CSDK 2.90 / 3.00 / 3.50 and EURO sign [14649]

This is something that I can help you with,

Try the following and respond with any problems that you have!

Setting DB_LOCALE=xx_xx.8859-15, xx_xx.cp1252, or xx_xx.utf8 should all
work,
As odbc is installed on windows CLIENT_LOCALE should be xx_xx.cp1252.

let me know if you have further problems,
Gerry

From:
"Jörg Volz" <Joerg@it-volz.de>
To:
ids@iiug.org
Date:
01/27/2009 03:51 PM
Subject:
CSDK 2.90 / 3.00 / 3.50 and EURO sign [14646]

Hy,

Situation given:

IDS 9.4/10.0 on Linux,
IDS 11.5 (Dev) on Windows XP
CSDK 2.90/3.00/3.50 on Windows XP

I tried to store the ââEURs¬ Euro sign through ODBC into any database
into a
varchar or char field.
No matter how I try, I receive a error like that:

[Informix][Informix ODBC Driver]Unspecified System Error = -21005.
(#21005)

I played around with client and database locales, no chance. Every special

character (Umlaut, sharp s etc ) is working fine, except the ââEURs¬
Euro
character.
But: with CSDK 2.40, it is workingââ'¬Â¦.

Is this a official bug, or am I missing some settings?

Thanks in advance,
Joerg Volz
-----------------------------------------------------------------------------

IT Handel und Beratung JÃf¶rg Volz
Bernhard-FrÃf¼h-Str. 7
77855 Achern
GERMANY

Tel: 07841-681651
Fax: 07841-681654
Mobil: 0170-2989757
Ust-ID: DE201383541

http://www.it-volz.de <http://www.it-volz.de/>

*******************************************************************************

Forum Note: Use "Reply" to post a response in the discussion forum.

*******************************************************************************

Forum Note: Use "Reply" to post a response in the discussion forum.

IT Handel und Beratung Jörg Volz
Bernhard-Früh-Str. 7
77855 Achern
GERMANY

Tel: 07841-681651
Fax: 07841-681654
Mobil: 0170-2989757
Ust-ID: DE201383541

http://www.it-volz.de

*******************************************************************************

Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• CSDK 2.90 / 3.00 / 3.50 and EURO sign
  Jörg Volz -- Tuesday, 27 January 2009, at 4:49 p.m.
  • Re: CSDK 2.90 / 3.00 / 3.50 and EURO sign
    Gerald Cousins -- Tuesday, 27 January 2009, at 11:31 p.m.
    • AW: CSDK 2.90 / 3.00 / 3.50 and EURO sign
      Jörg Volz -- Thursday, 5 February 2009, at 11:00 a.m.
      • Re: AW: CSDK 2.90 / 3.00 / 3.50 and EURO sign
        Gerald Cousins -- Thursday, 5 February 2009, at 1:44 p.m.
  • Re: CSDK 2.90 / 3.00 / 3.50 and EURO sign
    Sheshnarayan Agrawal -- Wednesday, 28 January 2009, at 1:16 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.