Re: NATIONAL CHARACTERSET

From: astalavista <nobody_at_nowhere.com>
Date: Tue, 29 Jul 2008 21:25:15 +0200
Message-ID: <488f6e9b$0$30912$426a74cc@news.free.fr>


OK thank you for your help ...

"Laurenz Albe" <invite_at_spam.to.invalid> a écrit dans le message de news: 1217321882.505296_at_proxy.dienste.wien.at...
> astalavista <nobody_at_nowhere.com> wrote:
>> What the practical difference/utility beween CHARACTERSET and
>> NATIONAL CHARACTERSET ?
>> In other words why NATIONAL CHARACTERSET was introduced ?
>
> The following is only my interpretation.
>
> Oracle adopted UNICODE rather slowly, and it is not until recently that
> they started recommending an UTF-8 character set for the database.
>
> Before, if you wanted UNICODE columns, you had to use the national
> character
> set for those.
>
> So I would say it is a leftover from those days, but a leftover that can
> come handy: if you have an old database that was created with a single
> byte character set, you can still have UNICODE columns in it without
> having to recreate the whole database.
>
> Yours,
> Laurenz Albe
Received on Tue Jul 29 2008 - 14:25:15 CDT

Original text of this message