Re: Import/Export Franch character problem. Can anybody Help?

Hi Sybrand,
thank you for your answer.
Before coversion ( imp/exp ) I checked all settings on OS/2 and NT server and client.

1. OS/2  Server character set is WE8ISO5589P1,
2. OS/2  Client character set is WE8ISO5589P1
3. NT Server and registry have WE8ISO5589P1
4. NT Client also WE8ISO5589P1 in registry.

For Export I used exp73 from NT client (and exp from OS/2 server) and I saw message: " converted to WE8ISO5589P1 character set without errors and warnings ". Import was done also without errors and warnings. But instead of French I saw black square

in SQL Plus and SQL. In server manager (svrmgr23) in NT dos mode I can see french very well.
As I know in dos mode NT uses 850 code page, and I tried to change registry for WE8PC850 but
result was the same I could not see French. Do you have any idea?

Thank you beforehand,
Iurie.

> Hi Jurie
> The problem here seems to be the export. Oracle requires environment
> variables, registry keys or whatever (I'm not too familiar with OS/2) to be
> set in the client session, or default values will be used. Of course, this
> is US7ASCII and your data will be converted automatically (and having lost
> that eighth bit, not much can be done). There should be messages to standard
> out and/or the log file in which character set the export has been written.
> Direct export however will always be written in the character set of the
> database. It will though not allow conversion during imp.
> Please check out HKEY\local machine\software\oracle on NT there should be a
> NLS_LANGUAGE setting there. The same applies to OS/2 and I don't know how
> they implement that.
>
> Hth,
Received on Tue Apr 13 1999 - 19:17:56 CDT