Re: Converting from WE8MSWIN1252 to WE8ISO8859P1

On Sat, 17 Apr 2004 15:30:30 +0200, Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote:

>On Sat, 17 Apr 2004 12:40:04 +0100, "Adam McDonagh"
><adam_at_ski2000.fsnet.co.uk> wrote:
>
>> Or am I going to have to
>>reinstall Oracle?
>
>Of course not.
>Export the affected database, create a new database with the correct
>characterset, import the database.

BTW: your advice surely does no good. As long as the DATABASE CHARACTERSET isn't set to the correct value, any export will corrupt your data. Before doing any export, you *have to* change the DATABASE CHARACTERSET to the right value, which depends of the contents of your database. One example: client OS is XP/german, NLS_LANG is <bla>.US7ASCII, DATABASE CHARACTERSET is US7ASCII => all settings are wrong, but it works and the contents of the database is WE8MSWIN1252. An export *will* corrupt your data, because a wrong characterset is documented in the exportfile. Before doing an export you *have to* change the DATABASE CHARACTERSET. For further readings please refer to metalink.  

--
Marc Blum
mailto:blumNOSPAM_at_marcblum.de
http://www.marcblum.de