Database Software

But i can't write arabic in SQL ... whats the issue?

What interface are you using to write your SQL in?  Is that interface configured to use a characterset that supports the languages you want?

I don't know all the different charactersets myself, but are you sure AMERICAN_AMERICA.AR8MSWIN1256 supports both Arabic and English?  Looks to me like it's more likely to just support 8 bit (single byte) characters and the American/English languages.

addition to BluShadow, does your database also support arabic or urdu chars?

can you post the result for this:

create table tmp_data (d nvarchar2(2000));

insert into tmp_data

select unistr('\FEB4') from dual;

select * from tmp_Data;

yes you can see the result

OraFAQ Forum: Forms » How to use unicode in Developer

I just saw this thread where mentioned that AMERICAN_AMERICA.AR8MSWIN1256. Support arrabic and ENglish

Hi,

output is not correct result, it should be this char:    ﺴ

I am not sure if sqlplus list it, can you try it from an GUI tool like SQL Developer please?

also setting NLS parameter doesn't mean your Operation System can handle these character. if OS doesn't support these charset then you won't be able to send it to Oracle as far as I know.

Now i tried in PLSQL Developer check the result

so you can use unistr to insert any kind of data as far as I understand. if you want to insert data in quotes like:

insert into table values ('ﺴ');

it won't happen because when you use it in between quotes, it will be converted to the string which probably will not be supported with your charset. what data do you want to insert? will this be done in regular basis?

Actualy in a software many tables and in every table there is 2 or 3 column where user will put information in arabic via Form...

When i try to insert Data Arabic via form 6i its saving but when i retrive data its showing like ??????????.

Please, provide the result of the following query in your database:

SELECT USERENV('language') FROM DUAL;

Also, do you use Forms6i client/server or web?

AR8MSWIN1256 does support Arabic and English though Oracle recommends AL32UTF8 (UTF8 in case of the old Forms6i).

Thanks,
Sergiusz

I am using 6i dekstop version not web based sir... and yes you can check the result of query

Now i change my NLS_CHaracter into

Now i change my NLS_CHaracter into

How do you change it?

-- Sergiusz

Using the command "ALTER DATABASE CHARACTER SET ...." is not supported - it will corrupt your database beyond repair.

The official process to do so is documented - https://docs.oracle.com/cd/E11882_01/server.112/e10729/ch11charsetmig.htm#NLSPG011

Here you can see how can i changed nls_character

$ sqlplus / as sysdba

SQL> SHUTDOWN IMMEDIATE;

SQL> STARTUP MOUNT;

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=SPFILE;  -- For RAC Node Only

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;

SQL> ALTER DATABASE OPEN;

SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;

SQL> SHU IMMEDIATE

SQL> STARTUP

80% Problem is resolve now i can save and retrive Arabic & English Both .... But I can't write Arabic auto.. i have to press ALT+SHIFT to change the language..

for example

i make a table with 2 Columns

English Varchar2(100) for saving english

Urdu Varchar2(100)      for saving Arabic

English is default when i click on Urdu COlumn i have to Press ALT+Shift to change my system writing into urdu

First, the procedure you described is not valid for migrations from WE8... to AL32UTF8. It corrupts all CLOBs in the database. It does not convert any existing data. Second, AL32UTF8 may work incorrectly with Forms6i. Forms6i are based on Oracle Client 8.0.6 and this client version does not know AL32UTF8. You should use the older, now deprecated, UTF8.

Second, to set the keyboard to Arabic when focusing an item, set the Initial Keyboard State item property to Local.

Thanks,
Sergiusz

There is no existing Data and dont need to convert it sir. and form 6i working very fine. i checked

and i already set Initial keyboard but still i have to press ALT+SHIFT to write urdu... english is default.. check here my setting

Why have you set this for the ENG item?  Have you tested with the ENG item as well?

As you have used an illegal procedure on your database, your database is now formally unsupported. If you call Oracle Support with a database issue, you may be asked to reproduce the problem on a database that was not converted using the presented method.

Thanks,
Sergiusz

i set this for arabic language sir not for English. but still not works