Problems with NLS_LANG settings

From: Ralf Pickart <ralf.pickart.NOSPAM_at_gmx.net>
Date: Wed, 31 Oct 2001 15:53:28 +0100
Message-ID: <9rp3an$us4mi$2_at_ID-113727.news.dfncis.de>

Hi,

[Quoted] until now we used the WE8ISO8859P1 characterset for our databases. To support other languages/charsets I have to set up a database with multibyte unicode characterset. Ok, so far so good... I choose UTF8 as database characterset and set NLS_LANG on client side to this value too (environment variable and windows registry).

Now I can insert data using SQL*Plus for Windows and get the same data back... but if I use the character-based SQL*Plus for DOS I get different (special) characters AND if I insert values using SQL*Plus for DOS I get these values only with SQL*Plus for DOS correctly. If I use SQL*Plus for Windows to retrieve these values I get wrong characters back.

Now my question:
Have I made a mistake in my NLS_LANG settings or is this the normal behaviour of national language support?

Regards
Ralf Pickart

[Quoted] Oracle DBA - empolis content management GmbH Received on Wed Oct 31 2001 - 15:53:28 CET

This message: [ Message body ]
Next message: Sybrand Bakker: "Re: Problems with NLS_LANG settings"
Previous message: Sybrand Bakker: "Re: what is the fastest way to update a big table (50000rows*20columns)"
Next in thread: Sybrand Bakker: "Re: Problems with NLS_LANG settings"
Reply: Sybrand Bakker: "Re: Problems with NLS_LANG settings"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message