Re: ORACLE 7 Multilingual Option

In a previous article, ka_at_tekla.fi (Ari Kaartinen) says:

>
>
> Hello all,
>
> I find the documentation on ORACLE 7 Multilingual Option rather
>terse. We work in multi vendor, multi platform environment and I
>would like to know what are the character encodings of supported
>character sets. The ones that I am most interested are we8dec
>and we8iso8859p1. I asked the local Oracle support but they did
>not seem to know.
>
> Any hints?

   I'm not sure what you are asking here. Yes Oracle supports both WE8DEC, and WE8ISO8859P1. You will want to specify the database character set using the CHARACTER SET clause of the CREATE DATABASE statement. This should be a superset of all of the character sets you wish to use.

   At the client/front-end level, the character set is specified either via the NLS_LANG environment variable (in Windows it is in your oracle.ini file), or by using the ALTER SESSION SET NLS_CHARACTERSET statement.

   If the Character set of the client differs from that of the server, Oracle will perform the transformation transparently.

--
   - Doug Harris
     Database Administrator, System Development Division,
     Statistics Canada.        ## WHERE ALL_OPINIONS.OWNER = USER ##