Re: something I can't understand with national character

"Franck" <nospam_at_toto.com> a écrit dans le message de news:pan.2003.12.24.06.17.11.959480_at_toto.com...
> 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 ?

None of both is better, depends on what you want to do. There is an introduction and links on Metalink, notes: 77443.1 and 69518.1 Read Oracle9i Database Globalization Support Guide, Chapter 5: Supporting Multilingual Databases with Unicode.

Regards
Michel Cadot Received on Wed Dec 24 2003 - 01:23:47 CST