. While standard for modern platforms, Developer 6i requires explicit configuration tweaks to cleanly render multi-byte UTF8 strings without truncating field lengths. Verifying Database Settings
In Developer 6i:
Ensure the Arabic or Urdu keyboard is added to the language bar so users can toggle between English and RTL input. 4. Forms 6i Property Settings To ensure proper visual display within your application: Writing Urdu or Arabic in Oracle Forms 6i Client-Side Windows Registry Settings (NLS_LANG)
If reports are executed via a web-cgi engine or report server, ensure the NLS_LANG variable is set to ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256 within the batch configurations, shell scripts, or specific registry profiles handling the runtime engine. Summary Checklist for Troubleshooting Likely Cause
Set the following at :
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_Dev6iHome\NLS_LANG (or under HKEY_CURRENT_USER\Software\Oracle )
In (Win95/NT/2000 client ) by using the blow details . Title : NLS Setting for Oracle Environment: ------------------------------- Oracle Forums Writing Urdu or Arabic in Oracle Forms 6i ALTER SYSTEM ENABLE RESTRICTED SESSION
Set the environment variable/registry key to match database character set.
Key values:
SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER SYSTEM ENABLE RESTRICTED SESSION; ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; ALTER SYSTEM SET AQ_TM_PROCESSES=0; ALTER DATABASE OPEN; -- Force the character set change (Use caution) ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8; SHUTDOWN IMMEDIATE; STARTUP; Use code with caution. 2. Client-Side Windows Registry Settings (NLS_LANG)