Oracle Database 10g Developer 6i Settings For Arabic Urdu Support Work [updated]

To set the language and territory, follow these steps:

The foundation for multi-language support is the database character set. The chosen set must support both English and Arabic characters. A. Recommended Character Sets To set the language and territory, follow these

ALTER SESSION SET LANGUAGE=AR; // for Arabic ALTER SESSION SET TERRITORY=EG; // for Egypt To set the language and territory

For Arabic and Urdu support, the character set must support bidirectional (BiDi) text and the Arabic script characters required by both languages. Use code with caution.

SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET'; Use code with caution.