Re: CharacterSet

From: Frank <fbortel_at_hotmail.com>
Date: 2000/07/04
Message-ID: <39619A3C.9CE9CEDC@hotmail.com>#1/1

Rob Zwartjes wrote:
>
> Hello there,
>
> when I installed oracle I selected US7ASCII as character set. At that time it
> looked OK by me but now I am missing the possibility having upper case and
> lower case mixture in my output. I found out that it has to be changed via
> NLS_LANG. So I put in my linux /etc/profile the following entrance:
> NLS_LANG=american_america.WE8ISO8859P1; export NLS_LANG
> Unfortunatly this doesn't work. Is this approach to straight forward or am I
> on the wright track?
>
> Can somebody help me out here?
> Thanks in advance,
> Rob

unfortunately, your database will only store 7 bits, therfor it is not possible to store extended characters. You will have to re-create you database with an 8 bit character set. like WE8ISO8859P1 (iso latin-1).
You can import your existing data.

frank Received on Tue Jul 04 2000 - 00:00:00 CDT