Re: NLS_LANG

Did you really expect Oracle to _change_ your data??? No way! If you stored in US7ASCII (which, btw, still is the default - silly, but true) you will never get your accent grave or c-cedille; that requires 8 bits in the database. Export, rebuild the database with 8 bits, import.

Tomasz Massouh wrote:

> Hi,
> The system is Oracle 7.3.4 on Aix 4.3.
> I would like to utilise the french characters in my database. I have
> exported the variable NLS_LANG=FRENCH_FRANCE.WE8DEC
> but oracle still keeps the new data in old format. Any suggestions?
> Thank you,
> TM

--
Gtrz,

Frank van Bortel