Re: PB with charset after migration

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 20 Feb 2003 23:29:43 +0100
Message-ID: <vkla5v8e3lt3d8k871bc03ve82am8g9ogu@4ax.com>

On Thu, 20 Feb 2003 23:24:01 +0100, "FLAMENT Arnaud" <flament.arnaud_at_wanadoo.fr> wrote:

>Hello everybody,
>I'm a young dba, and I think i made an error during a database migration.
>
>I made a migration of an oracle 7.3.4 to oracle 8.1.7 and it's OK.
>But the oracle 7.3.4 have nls parameter for France (charset WE8ISO8859P1)
>and the oracle 8.1.7 have nls parameter for America (charset US7ASCII).
>
>I want to know how to repair my mistake (because some letter like "é" or
>"à" are replaced by "e" or "a").
>
> If someone can help me.
> Thanks a lot. (sorry for my poor english)
>

You'll need to re-execute the migration, as due to NLS settings, bit 7 was stripped, and you won't be able to 'repair' that ever.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Feb 20 2003 - 16:29:43 CST