Re: something I can't understand with national character

"Franck" <nospam_at_toto.com> a écrit dans le message de news:pan.2003.12.23.19.35.41.533779_at_toto.com...
> when my sql script for create database is like that :
>
> create database base
> datafile '/oracle/data/system.dbf' size 100M
> logfile
> group 1 ('/oracle/data/log1.log',
> '/oracle/data/log2.log') size 512k,
> group 2 ('/mnt/ext/data/log1.log',
> '/mnt/ext/data/log2.log') size 512k
> noarchivelog
> maxinstances 1
> maxlogfiles 4
> maxlogmembers 4
> maxdatafiles 20
> maxloghistory 100
> character set WE8ISO8859P1
> national character set UTF8;
>
> it is ok, it works but whe it is like that :
>
> create database base
> datafile '/oracle/data/system.dbf' size 100M
> logfile
> group 1 ('/oracle/data/log1.log',
> '/oracle/data/log2.log') size 512k,
> group 2 ('/mnt/ext/data/log1.log',
> '/mnt/ext/data/log2.log') size 512k
> noarchivelog
> maxinstances 1
> maxlogfiles 4
> maxlogmembers 4
> maxdatafiles 20
> maxloghistory 100
> character set WE8ISO8859P1
> national character set WE8ISO8859P1;
>
> It doesn't work, only national character set change, why we8iso8859p1
> works for character set and not for national character set ?
>
> Thanks for help

In 9i, only AF16UTF16 or UTF8 can be specified for national character set.

Regards
Michel Cadot Received on Tue Dec 23 2003 - 15:30:34 CST