| Setup Arabic Language [message #470119] |
Sun, 08 August 2010 13:47  |
esraa90
Messages: 63
Registered: May 2008
Location: EGYPT
|
Member |
|
|
Dear All,
My arabic data appears like ???????
How could I setup Arabic for forms , database?
I have 10G oracle database, forms,reports.
Please Help.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Setup Arabic Language [message #470420 is a reply to message #470273] |
Mon, 09 August 2010 17:42  |
esraa90
Messages: 63
Registered: May 2008
Location: EGYPT
|
Member |
|
|
no it is in Database itself.
I use sql icon and connect to my database.
I use the following command for example:
insert into my_table values(1,'arabic text');
the record insert in table like:
1 ???
|
|
|
|
|
|
|
|
| Re: Setup Arabic Language [message #470879 is a reply to message #470614] |
Wed, 11 August 2010 04:53 |
esraa90
Messages: 63
Registered: May 2008
Location: EGYPT
|
Member |
|
|
Dear sir,
Thankyou for reply.
I read the document.
I think I know whers is the problem now, but I don't know how to solve.
I used the following command to check language parameter in Oracle:
--------------------
[b]Select userenv('language') from dual;
the answer was:
AMERICAN_AMERICA.WE8MSWIN1252
------------------
althou,in windows registry oracle home I have:
ARABIC_EGYPT.AR8MSWIN1256
or
AMERICAN_AMERICA.AR8MSWIN1256
---------------------
How could I change WE8MSWIN1252 in database, to AR8MSWIN1256 ??
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Setup Arabic Language [message #472014 is a reply to message #471978] |
Wed, 18 August 2010 05:29 |
esraa90
Messages: 63
Registered: May 2008
Location: EGYPT
|
Member |
|
|
after reading another doument, I understnd that I sould run CSMINST.sql sript first.
so I ran script csminst.sql
then csalter.plb
the error changed to the following;
SQL> connect sys/sys as sysdba
Connected.
SQL> @@F:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\csalter.plb
4 rows created.
Function created.
Function created.
Procedure created.
This script will update the content of the Oracle Data Dictionary.
Please ensure you have a full backup before initiating this procedure.
Would you like to proceed (Y/N)?y
old 6: if (UPPER('&conf') <> 'Y') then
new 6: if (UPPER('y') <> 'Y') then
Checking data validility...
Sorry only one session is allowed to run this script
PL/SQL procedure successfully completed.
Checking or Converting phrase did not finish successfully
No database (national) character set will be altered
CSALTER finished unsuccessfully.
PL/SQL procedure successfully completed.
4 rows deleted.
Function dropped.
Function dropped.
Procedure dropped.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
