Characters losts during Import (8.1.6) -> (9.2.0.6)

From: Guitarator <d.jeanneret_at_wanadoo.fr>
Date: 5 Jul 2006 01:01:02 -0700
Message-ID: <1152086462.805107.251020@p79g2000cwp.googlegroups.com>

Hi
sorry to come back again. I must to do Export one on my data schema from my 8.1.6 server to another 9.2.0.6. What is the best way ?

First test: I does my export => i've a kabalistic character after Import on my 9.2.0.6
Seconc test: Setting the NLS_LANG in environement to .WE8ISO8859P1 before my Export => on import in 9.2.0.6 I've the same problem.
Third test: I don't know. Migrate the database in another Charcater Set ?

8.1.6 NLS Parameters

NLS_LANGUAGE =  FRENCH
NLS_TERRITORY = FRANCE
NLS_CHARACTERSET =  US7ASCII
NLS_SORT = FRENCH
NLS_NCHAR_CHARACTERSET = US7ASCII

9.2.0.6 NLS Parameters

NLS_LANGUAGE = FRENCH
NLS_TERRITORY = FRANCE
NLS_CHARACTERSET = WE8ISO8859P1
NLS_SORT = FRENCH
NLS_NCHAR_CHARACTERSET = AL16UTF16

Thanks you very much for all welcome answers Denis Received on Wed Jul 05 2006 - 03:01:02 CDT