A default installation of 11g R2 11.2.0.1.0 may not be very pleasant for Oracle developers who are still working with Developer 6i suite!
Our test lab installation has by default taken “NLS_CHARACTERSET
As a workaround, we dropped the database and re-created it using database character set “WE8MSWIN1252” and later with “AR8MSWIN1256” as we needed Arabic support
An interesting discussion could be found here about the character set
Now, we are able to connect to the database, continue our development using developer 6i
Note: Please consult Oracle prior applying such workaround solutions to production environments. Our main intention was to find out a method to connect to 11g R2 database from Developer 6i products.
Regards,
admin
This works like a charm – thanks…
You are welcome James :)
We do hope that you read the Oracle forum thread, linked to this post. If you haven’t, please do.
Experts have much to talk about workaround solutions there.
regards,
admin
Thank you , ur solution had worked for us..
Hi Admin,
how can we change the character set from WE8MSWIN1252 to AR8MSWIN1256 after creating the database? please help on this.
Regards,
Imran
The best we would suggest is, take a full backup of your database, double check whether the backup is fully operational by trying to import.
Then drop the database with wrong character set and create a new database with correct set.
Import of your objects with possible character conversions.
Refer the following: http://anuragkumarjoy.blogspot.com/2013/09/how-to-change-character-set-in-oracle.html
regards,
can you give detailed setting of ora files for connecting forms 6i and database 11gR2 please, because i am not able to conenct them.
Hello Arvind
If you are not on a production instance, drop the database and create a new one with a different character set other than NLS_CHARACTERSET AL32UTF8.
This should let developer 6i products to connect to 11G. Please note, if you have developer 6i installed in Wondows 7 onwards OS, You will not able to achieve all the functionalities.
Regards,
I need your technical guidance related to Urdu Language Support in Oracle Forms & Reports 6i.
Below are the details of requirement and R&D effort we made to achieve the desired output:
Requirement:
============
We have an application in Oracle Forms & Report 6i and Database 10g Rel 2.
There is a client requirement to provide Urdu support in this application. We have to enter Urdu data in few forms and print it in PDF reports.
Problem:
===========
We created new database with AL32UTF8 Character Set with same National Character Set for Unicode support.
Developed a form and report on a table with NVARCHAR2 data type.
Edited nls_lang entries in Registry to AMERICAN_AMERICA.AL32.UTF8
Installed Urdu Support in WinXp
Database stores and retrieves Urdu and displays Oracle SQL Developer.
Oracle form stores/retrieves Urdu characters but it fails to type complete words and sentences.
On typing 2nd, 3rd characters of a words all characters position mix up randomly and produce garbage.
Oracle report don’t show Urdu characters in run-time but it shows the same in Report Builder.
Please suggest solution of the above stated problems.
We already discussed this topic many times and including Oracle communities, many places have asked you to try with AMERICAN_AMERICA.AR8MSWIN1256.
I still trying to resolve it but not success. Could your please update me step by step solution in Forms6i level and Database level.
thank you for your reply.
Hello there
Setup registry values for both database, forms NLS language as AMERICAN_AMERICA.AR8MSWIN1256
Make sure your client computers have the same language settings in the registry and Urdu keyboard language is enabled
Arabic being the closest to right to left input, this should resolve your issues
Unfortunately, I am not familiar with Urdu, however the above said always worked for our Arabic support.
regards,
Hello
You mean this right?
Yes. at the time of typing its show in URDU / ARBIC language. But When I Saved and Make Query. Its Shows Mixing of difference characters.
Well, the screen shot is from a queried screen. The data is committed to the database. Please check your yahoo email given with the comment. I sent you a email asking for some details.
waaoooooo. Its not showing from my side. My Side is as per following:
CUS_NAME_U
——————————————————————————–
¿¿¿¿¿¿¿¿¿ ¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿ ¿¿¿¿¿¿ ¿¿¿¿
¿¿¿¿¿¿¿¿ ¿¿¿¿¿¿¿¿ ¿¿¿¿¿¿¿ ¿¿¿¿ ¿¿¿¿¿¿¿ ¿¿¿¿¿¿ ¿¿¿¿¿¿¿¿¿¿
ÔÁÆÃ
ÁÚÇÏÚÑ Ç¿ ¿ÑÀÁ¿ Ý ¿ÀÿÇÄÀÚÓ
Email not received. send back again
https://windows7bugs.wordpress.com/2016/11/06/oracle-database-10g-developer-6i-settings-for-arabicurdu-support/
Dear
Its still not resolve that is the reason i m trying to ask every possible places.
Hi again
You are asking to help with products those are obsolete from a decade and more (Minimum forms 6i). I doubt many forums, the younger creed of developers know anything about client server architecture and developer 6i. Urdu being used, most probably only in Pakistan, your chances to get specific instructions for the said language is going to be very difficult. However, if I could recollected Oracle communities had few queries about setting up Urdu. I’m not promising anything, it is too early. My colleague is a Pakistani and if I get enough time to setup a test environment, I will try to help you.
regards,
I have a application built in dev6i 8.0.6 (32 bit) operting system win-2003. I installed oracle10g (32 bit) and import data into it. now problem is this that old blobs (pics) getting displayed in forms but new pics data not getting saved OR not viewable in forms. i try to view it using sql-developer but unable to do so. Need your advise. thanks.
Hello there, sorry for replying you late. I don’t have any idea about the situation explained by you. However, it looks challenging and I will see whether I could come up with some solutions. Please let me know your 10g version