Re: Fetching Extended-Ascii Character with Pro*C

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 09 Jan 2002 19:21:33 +0100
Message-ID: <vf2p3ugeuaaf0ld6duk83g32mcfp2vsna3@4ax.com>

On Wed, 9 Jan 2002 10:50:47 +0100, "Piergiorgio Volpago" <piergiorgio.volpago_at_ubiest.com> wrote:

>I've a problem while fetching non standard ascii chars in a Pro*C program:
>I've declared a varchar variable; my select statement returns strings like:
>
>LA
>LE
>LI
>LO
>LU
>LY
>LÄ
>LÉ
>LÖ
>LÜ
>
>When I fetch result in my varchar variable LÄ becomes LA, LÖ becomes LO a so
>on...
>I'm working in a IBM/AIX system.
>
>Any suggestion?
>
>ThankYou
>-------------------------------------------------------
>Piergiorgio Volpago
>
>UbiEst S.p.A.
>Via E. Reginato, 87
>31100 Treviso, Italy
>phone: +39 (0)422 210194
>mailto: piergiorgio.volpago_at_ubiest.com
>
>

You did set the environment variable NLS_LANG to American_America.WE8ISO8859P1
?

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jan 09 2002 - 12:21:33 CST