Re: pb setting NLS_LANG with mod_perl 1.99_14et DBD::Oracle

[prev] [thread] [next] [Date index for 2005/04/27]

Jean-Paul COGNET wrote:
> Hi Stas,
> Good advice !!
> I've found that a user have a similar problem using PHP, and that the =
only
> avalaible value for NSL_LANG is this case was
> 'American_America.EE8ISO8859P2'
> I've tried this value and it works, but with bad accents.
> "ou entrer l'heure d'enl=E8vement pass=E9e ou =E0 venir. Entrer =
=E9toile si
> l'enl=E8vement ne pourra pas se faire"
> becomes
> "ou entrer l'heure d'enl?vement pass=E9e ou ? venir. Entrer =E9toile =
si
> l'enl?vement ne pourra pas se faire"
>=20
> BUT with this strange value
> 'American_America.WE8ISO8859P1'
> it seems to work fine.
> "ou entrer l'heure d'enl=E8vement pass=E9e ou =E0 venir. Entrer =
=E9toile si
> l'enl=E8vement ne pourra pas se faire"
> stays
> "ou entrer l'heure d'enl=E8vement pass=E9e ou =E0 venir. Entrer =
=E9toile si
> l'enl=E8vement ne pourra pas se faire"
>=20
> Maybe, Oracle doesn't like France ;-)

Hi,

Setting NLS_LANG to "french_france.WEISO8859P1" or =
"french_france.WEISO8859P15"
and LC_ALL to "french" or "C" seems to work.


Sylvain