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

[Sylvain CRESTO]

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�vement pass�e ou � venir. Entrer �toile si
> l'enl�vement ne pourra pas se faire"
> becomes
> "ou entrer l'heure d'enl?vement pass�e ou ? venir. Entrer �toile si
> l'enl?vement ne pourra pas se faire"
> 
> BUT with this strange value
> 'American_America.WE8ISO8859P1'
> it seems to work fine.
> "ou entrer l'heure d'enl�vement pass�e ou � venir. Entrer �toile si
> l'enl�vement ne pourra pas se faire"
> stays
> "ou entrer l'heure d'enl�vement pass�e ou � venir. Entrer �toile si
> l'enl�vement ne pourra pas se faire"
> 
> 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