Re: Export-Import across character sets

Sybrand Bakker wrote:
>
> Especially for US citizens:
> Please note WE8ISO8859P1 is equivalent with the Latin-1 alphabet and has
> definitely not to do with Iceland only.
> On NT WE8ISO8859P1 is already the default and rightly so as it covers the
> major European languages.
> In an internationalizing world, with many international firms with
> international data in their databases, creating a database in US7ASCII is
> very undesirable, not to say more, not to say it is typically US-centric.
>
> Best regards,
>
> --
> Sybrand Bakker, Oracle DBA
> Kenneth C Stahl <BlueSax_at_Unforgettable.com> wrote in message
> news:384FCC02.8E51C83D_at_Unforgettable.com...
> > For some reason that totally escapes me, a data base that I work with was
> > created with the WE8ISO8859P1 character set instead of US7ASCII. Does
> > anyone know if there would be adverse effects if an export were taken from
> > that database and then imported into a database with the US7ASCII
> character
> > set? We are no where near Iceland so nothing has been inserted into the
> > database which would use Icelandic characters.

Then the followup question would be: Does Oracle have any definite guidance on this subject? I want to establish a standard, and if WE8ISO8859P1 is better then US7ASCII then I'm willing to do this, but I want to do it for the right reasons rather than on a weak reason that the US7ASCII is US-centric.

By the way, there are a series of scripts in the $ORACLE_HOME/rdbms/install/rdbms directory the file rdbms.vrf lists WEISO8859P1 as the Icelandic character set. Received on Thu Dec 09 1999 - 13:57:41 CST