asked on

Question marks appear instead of stored Arabic Data in an Oracle 9i.

Hi experts,

I have an Oracle 9i DB in which I need to store Arabic Data but when I retrieve data , just question marks appear instead of arabic characters.

Is there a way to make my DB support arabic characters???

it is ok for me to create a completely new database and then re insert my sample data one by one, I have the insert statements ready.

thanks in advance, any help very much appreciated.

Harisha M G

Hi isaihat,

You should setup the database for Unicode support
http://docs.openlinksw.com/lite/unicode.html

Bye
----
Harish

isaihat

ASKER

how can i make it in sql format in setup the database?

Harisha M G

From that site:

Using the Oracle ?Database Configuration Assistant? wizard follow the options for creating a new database, selecting the ?custom? option when presented and you will during the configuration of this Custom database be allowed to ?Change the Character Set?, at which point this can be changed to UTF8.

To check the character set in use by your database, execute the following query in SQL*Plus:

SQL> SELECT parameter, value FROM nls_database_parameters
WHERE parameter = 'NLS_CHARACTERSET';

PARAMETER VALUE
------------------ ---------------------
NLS_CHARACTERSET UTF8

SQL>.

Unicode support is dependent on the Unicode features available through the Oracle Call Interface (OCI). OCI 8.1.5 supports inputting Unicode data into a database and retrieving Unicode data from a database.

The Following Oracle Data types can be using for storing Unicode data:

CHAR
VARCHAR
VARCHAR2

ASKER CERTIFIED SOLUTION

mnrz

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mnrz

thanks and hope u success