Urdu support in Oracle Forms 9i
Requirement:
============
We have an application in Oracle Forms & Report 9i Rel 2 and Database 9i 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.
Further more, Our group of applications works in Materialized View Replication environment [5-6 applications consolidate data at a Central Database]. If we change Character Set of one application's database to Unicode then is it must to apply the change in all databases of replication group.
Please suggest if Oracle IDS 9i or 10g provides support for Urdu. If yes then please suggest solution of the above stated problems.
Looking forward for your quick response.