something I can't understand with national character

From: Franck <nospam_at_toto.com>
Date: Tue, 23 Dec 2003 20:35:41 +0100
Message-ID: <pan.2003.12.23.19.35.41.533779@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 Received on Tue Dec 23 2003 - 13:35:41 CST