i 've migrated a sql server 2000 database to oracle 11G, on the 11g side , encoding was set on France.French.AL32UTF8, but now i've migrate data i realize all accentuated char are shown with ?
could you help me please
and the NLS parameter in the sqlldr script was set to AL32UTF8 too
so is it just a setting or do i have to do all the migratin again ?
i realize too that it is not related to the windows client i think
because if i sqlplus the database from the db server itself, i see accentuated char with ?
i really don't know what to do now, i chose AL32UTF8 for not having problem, but it was an error i think
i tried FRENCH_FRANCE.AL32UTF8 FRENCH_FRANCE.UTF8 FRENCH_FRANCE.WE8ROMAN8 FRENCH_FRANCE.WE8MS1252 NLS_LANG variable environnement on the oracle server, i never display accents correctly
if someone could give me the correct approach , it would be great