Arabic character Support on HPUX

[Dayanand Naik]

Hi Folks,

'm running HP-UX 11.00 on A400 Class server, running Oracle 8i database, now our dba has created a database instance and wants to enter data in arabic format.

My qts :

1) Does HP-UX support Arabic character set?
2) What kind of Terminal emulation should i use configure for achiving the above result.
3) Is there any other way out...

Suggestion Welcomed....

Regards,
Dayanand Naik

[Steven Sim Kok Leong · Accepted solution]

Hi,

First, check to see what locales are currently installed on your system by typing:

# locale -a

Check to see what languages are installed on your system by typing:

# /usr/sbin/swlist -l fileset International

If it was not installed, you can install it from the HP-UX Core media via swinstall.

Once the language has been installed, then you can proceed to set the LANG environment variable for the user requiring the Arabic character support.

For Arabic (Algeria), use any of the following:
1) ar_DZ.arabic8
2) ar_DZ.utf8

For Arabic (Saudi Arabia), use any of the following:
1) ar_SA.arabic8
2) ar_SA.iso88596
3) ar_SA.utf8

For example, if you are using ar_SA.arabic8, then:

Set for .dtprofile or .profile:

export LANG=ar_SA.arabic8

Set for .cshrc or .login,

setenv LANG ar_SA.arabic8

For further information, look at the document "Configuring HP-UX for Different Languages" at:

http://www.docs.hp.com/hpux/onlinedocs/5971-2271/5971-2271.html

Hope this helps. Regards.

Steven Sim Kok Leong

[T. M. Louah]

..The following doc discusses HPUX biderectional Language Support:
http://docs.hp.com/cgi-bin/fsearch/framedisplay?top=/hpux/onlinedocs/B1171-90148/B1171-90148_top.html&con=/hpux/onlinedocs/B1171-90148/00/00/63-con.html&toc=/hpux/onlinedocs/B1171-90148/00/00/63-toc.html&searchterms=character%7csupport%7cArabic&queryid=20020127-074117

..Intersting discussions are found on these Threads:
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x520e72106351d5118fef0090279cd0f9,00.html
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xb8fb6c96588ad4118fef0090279cd0f9,00.html

G'd luck
t++

[Dayanand Naik]

Hi Steven,

Thanks for your message, I did solve the same. but my dba says that how can he type arabic characters in the the database when he uses sqlplus to add records and via any third part application software.

Suggestion Welcomed

Regards,
Dayanand Naik.

[Steven Sim Kok Leong]

Hi,

The following link may help:

http://jordan.fortwayne.com/oracle/817.html

Accordingly, you need to specify the ORA_NLS33 and NLS_LANG in your login profile.

Example for Oracle 8.1.7,

1) Set your ORA_NLS33 (same for all languages):

ORA_NLS33=/u01/app/oracle/product/8.1.7/ocommon/nls/admin/data; export ORA_NLS33

2) Set your NLS_LANG:

For .dtprofile or .profile,

export NLS_LANG=arabic

For .cshrc or .login,

setenv NLS_LANG arabic

Hope this helps. Regards.

Steven Sim Kok Leong