Exporting Arabic Table Data

[dan86]

It isn't possible to export Arabic data from tables? Isn't there a place to change the character encoding of the export?

 

[Marco Kalter]

The character encoding is controlled by the character set of the NLS_LANG setting of your Oracle environment.

 

[dan86]

Oh I see.

Excuse my questions, but I'm not very good in Oracle.
1- I'm using NVARCHAR2 as the column type where I might have Arabic letters. Does that matter?

2- NLS_LANGUAGE: AMERICAN
NLS_CHARACTERSET: WE8MSWIN1252
NLS_NCHAR_CHARACTERSET: AL16UTF16

If I try @.[%NLS_LANG%]. it gives me 'Error reading file' and HOST ECHO %NLS_LANG% returns %NLS_LANG%

Help in a way to export the Arabic letters would be greatly appreciated.

 

[Marco Kalter]

Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[dan86]

I have sent you the text by e-mail.

Anyway, from what I see in the text is that the NLS_LANG is AMERICAN_AMERICA.WE8MSWIN1252

Anyway I can change it?

 

[dan86]

So anyway I can export the Arabic data?