Re: NLS - Language, Characterset, Storage, etc. questions

From: s. hunter <sarahxhunter_at_NOSPAMTHANX.hotmail.com>
Date: 2000/02/01
Message-ID: <38970464.CC346530@NOSPAMTHANX.hotmail.com>#1/1

Argosy,

As far as I am aware, the parameters specified in your UNIX environment don't have any bearing on the storage of characters in the database. By default a database is created with the 7ASCII character set. If you want it to be able to store European characters (such as accents) you must use 8WEISO8859P1 and specify this on database creation. This is because the accents present in some European languages are stored as an extra bit and the character set tells Oracle how to store them. Obviously, languages such as Chinese or Japanese also require different (multi-byte) encoding.

You can override the default NLS for display purposes, so check Oracle documentation.

HTH Sarah Received on Tue Feb 01 2000 - 00:00:00 CST