Re: Database character set

In article <1994Jul26.121530.21098_at_news.unige.ch>, pham_at_fapse.unige.ch (PHAM VAN THANH) wrote:

> When we created our ORACLE V.7.0.16 database, we have specified the character
> set WE8ISO8859P1 for the database. Do we forget anything in our import
> procedure that prevents us to use Swiss French language in our database? Any
> help is welcome. Thanks in advance.

The important step in NLS is to set the NLS_LANG environment before importing/inserting/updating anything in the database. You would set NLS_LANG to french_switzerland.we8iso8859p1 (if you like french error messages in sqlplus, but the important part is the codepage we8iso8859p1).

Hope this helps
LM

-- 
Leo Mannhart
Planning Office
University of Zurich               phone: ++41 1 257 23 34
Kuenstlergasse 15                    fax: ++41 1 257 22 12
CH-8001 Zurich, Switzerland        eMail: mannhart_at_zuv.unizh.ch