Skip to Main Content
Forums

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Unicode fonts in Oracle Forms 11g

SoofiOct 20 2015 — edited Oct 30 2015

Hi All,

I am using Oracle Forms 11g with 12c database.

I installed Unicode version in DB so that I can able to store multiple languages in my DB.

(My application need to support English and Arabic)

Currently I installed Forms and Reports with the following NLS_PARAM

NLS_LANGUAGEARABIC
NLS_TERRITORYSAUDI ARABIA
NLS_CURRENCYر.س.
NLS_ISO_CURRENCYSAUDI ARABIA
NLS_NUMERIC_CHARACTERS.,
NLS_CALENDARGREGORIAN
NLS_DATE_FORMATDD/MM/RR
NLS_DATE_LANGUAGEARABIC
NLS_CHARACTERSETAL32UTF8
NLS_SORTARABIC
NLS_TIME_FORMATHH12:MI:SSXFF PM
NLS_TIMESTAMP_FORMATDD/MM/RR HH12:MI:SSXFF PM
NLS_TIME_TZ_FORMATHH12:MI:SSXFF PM TZR
NLS_TIMESTAMP_TZ_FORMATDD/MM/RR HH12:MI:SSXFF PM TZR
NLS_DUAL_CURRENCYر.س.
NLS_NCHAR_CHARACTERSETAL16UTF16
NLS_COMPBINARY
NLS_LENGTH_SEMANTICSBYTE
NLS_NCHAR_CONV_EXCPFALSE

Now when I compile any form it turns right to left while displaying and also the numbers,date and alerts are in Arabic.

All I need is

To Store Arabic values in my DB.

To display Arabic prompts / labels in my Forms.

To display Arabic text that are stored in db through my Reports.

For this What should be my system config? NLS Config? Forms Config? etc.,

Please share your valuable recommendations.

Thanks in advance.

Regards,

Soofi

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 27 2015
Added on Oct 20 2015
#forms, #moved-from-devops, #reports
13 comments
3,291 views