Re: French characters

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 14 May 2006 22:24:06 +0200
Message-ID: <6a4f6219ed8nc9bc9a4g5cn34ffj1o54en@4ax.com>

On 14 May 2006 10:50:27 -0700, "Alt255" <alt255.2005_at_gmail.com> wrote:

>Thanks for the input guys. It's a little over my head. I changed
>nls_lang=WE8MSWIN1254 but the connection failed because it considers it
>invalid.. Does anyone know what I need to configure?

nls_lang consists of three parts
<language>_<territory>.<characterset>

For the first two you can safely use American_America

so nls_lang becomes

American_America.WE8MSWIN1254

If that doesn't work, remove NLS_LANG
connect and query
v$nls_valid_values

This will reflect your actual installation

Hth

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun May 14 2006 - 15:24:06 CDT