Re: Oracle8i: Create database question

    With 8.1.5 and 8.1.6 on Solaris or NT the default character set is Western European 8 bit - which really makes sense these days. I wouldn't go with ASCII7 unless you have to. The other two you can find in the install documentation or by running the Gui database creation assistant and looking at the defaults.

    By the way, if you are running under UNIX be sure to set the environment variable NLS_LANG to eight bits. The default language for the database is eight bits, but Oracle assumes the default NLS_LANG setting is seven bits! So you can export from an 8 bit machine and import into an 8 bit machine but still lose all of the second 128 character information (accent marks, etc.).

Van

"Huy Vu" <huyv_at_usa.net> wrote in message news:968379962.351926_at_news.aei.ca...
> Hi all,
>
> I forgot to put these options under 'CREATE DATABASE' clause:
>
> CREATE DATABASE "DB1"
> Maxinstances 8
> Maxlogfiles 32
> Character set "US7ASCII"
> National Character Set "US7ASCII"
>
> What are the values by default of the options above? What happen if I
 don't
> put 'Character Set' and 'National Character Set' in creation of the
> database?
>
> Thanks in advance for any advise.
>
> DH.
>
>
Received on Fri Sep 08 2000 - 17:18:33 CDT