Le Tue, 23 Dec 2003 22:30:34 +0100, Michel Cadot a écrit :
>
> "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
Thanks a lot, which one is the best ?
Received on Wed Dec 24 2003 - 00:17:13 CST
