This content has been marked as final. Show 9 replies
Please try this (its the same but with 1 modification):
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE AR8MSWIN1256;
But its exactly the same no change in the output :(
Why on earth are you using the undocumented INTERNAL_USE command? The name alone should strongly imply that this isn't something that normal users should be playing with. It is extremely likely that you've corrupted your database.
Do you have a backup of your database taken before you corrupted it? If so, can you restore that backup? Once you do that, tell us what character set you're starting with. If you are implying that there is existing data in the database, what character set is that data encoded with? Can you DUMP the data to verify this?
what is your NLS_LANG parameter?
try change to:
NLS_LANG=ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256;
NLS_LANG=ARABIC_UNITED ARAB EMIRATES.AR8ISO8859P6;
it is shown now like this:
ØÈÏ Çææ? Óæ?Çè ØÈÏ Çææ? ÓØÏ ÇæÔçæÇè "ÊÐå?Ñ" èÑÌ? ÊÓæ?ç ÈÍË ÅÏÇÑÉ ÇæçØæ?çÇÊ ä? ç?
I did export NLS_LANG='ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256';
and tried the other options too. I am doing it on a test database.
As noted, INTERNAL_USE command is not documented and WILL corrupt your database. Restore your database from a good backup and then use the OFFICIAL documented conversion procedures
Do not waste time trying random solutions, especially the undocumented ones with INTERNAL_USE clause, which is pretty dangerous to the database, unless you use it under Oracle's supervision. There are usually supported ways to do the same thing.
As already asked, the first and most important question is: what is the previous character set of your database?
Actually i didnt work with db11g but i think this will help u specially my last post it is tested &worked for me in db10g.
Re: How can you type from RIGHT-to-LEFT (i.e. Arabic style) in Forms?