While Arabic settings often work for Urdu, ensure the Windows System Locale is set to Urdu in the Control Panel (Region & Language settings) to enable proper keyboard input and font rendering. 3. Application Design Settings
NLS_LANG=ARABIC_UNITED ARAB EMIRATES.AL32UTF8 NLS_SORT=ARABIC NLS_DATE_LANGUAGE=ARABIC export NLS_LANG NLS_SORT NLS_DATE_LANGUAGE
Important: The territory UNITED ARAB EMIRATES gives Arabic number and calendar formatting. Use ARABIC for language.
Note: If your database character set is US7ASCII or WE8MSWIN1252, it cannot store Arabic or Urdu characters natively. You will need to migrate the database character set using the Oracle Data Pump or the CSSCAN/CSALTER utilities. 2. Operating System Setup (Windows Client) While Arabic settings often work for Urdu, ensure
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.
Your database character set must be one that supports Arabic/Urdu scripts.
If the database is already created with a Western charset (like WE8MSWIN1252 ), you may need to use ALTER DATABASE CHARACTER SET INTERNAL_USE AR8MSWIN1256; (requires SYSDBA privileges and restricted mode). 2. Client-Side Registry (Developer 6i) Use ARABIC for language
NLS_LANG = ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256
To make text fields read from right to left and accept Arabic/Urdu scripts natively, modify the properties within the Forms Builder ( .fmb ). Canvas and Item Properties Open your form in .
For text items intended to display Arabic or Urdu: not as empty squares.
By following this guide, you can ensure that your forms display بسم اللہ and السلام علیکم correctly – and that Urdu letters like ڑ and ے appear as intended, not as empty squares.
Developer 6i was released before Unicode became standard. It uses ASCII and code pages (character sets). It does not fully support UTF-8 for display in all controls, but you can store and retrieve Arabic/Urdu text if configured correctly.
The Direction property on the Oracle Forms canvas or text item is still set to Left-to-Right, or the local machine lacks proper RTL text rendering layout engines.
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
SELECT parameter, value FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET';
