Skip to Main Content

Oracle Database Discussions

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.

Urdu language Support in Oracle 9i!!

406882Oct 30 2003 — edited Nov 25 2003
I have started working on an application which worked on URDU Language. its front-end will be in URDU and the database will be Oracle 9i. So i have some query as far as database part is concerned...

- Has Oracle 9i got the support of Urdu Language???
- Will data be saved in urdu font or english font or in some UniCode format


Any OTN Member reply's will be highly obliged...

Regards
Salman Iqbal

Comments

oradba
Hello,
according to
Oracle9i Database Globalization Support Guide
Release 2 (9.2),

URDU is not supported.

Regards
Werner
403551
You can see with this view what are the laguages supported
by your Oracle Server.

1* select * from v$nls_valid_values
SQL> /

PARAMETER VALUE
---------------------------------------------------------------- ------------------
LANGUAGE AMERICAN
LANGUAGE GERMAN
LANGUAGE FRENCH
LANGUAGE CANADIAN FRENCH
LANGUAGE SPANISH
LANGUAGE ITALIAN
LANGUAGE DUTCH
LANGUAGE SWEDISH
LANGUAGE NORWEGIAN

Joel P�rez
364783
These are the 58 language supported in 9i Release 9.2.0.1.0:
AMERICAN
ARABIC
ASSAMESE
BANGLA
BENGALI
BRAZILIAN PORTUGUESE
BULGARIAN
CANADIAN FRENCH
CATALAN
CROATIAN
CZECH
DANISH
DUTCH
EGYPTIAN
ENGLISH
ESTONIAN
FINNISH
FRENCH
GERMAN
GERMAN DIN
GREEK
GUJARATI
HEBREW
HINDI
HUNGARIAN
ICELANDIC
INDONESIAN
ITALIAN
JAPANESE
KANNADA
KOREAN
LATIN AMERICAN SPANISH
LATVIAN
LITHUANIAN
MALAY
MALAYALAM
MARATHI
MEXICAN SPANISH
NORWEGIAN
NUMERIC DATE LANGUAGE
ORIYA
POLISH
PORTUGUESE
PUNJABI
ROMANIAN
RUSSIAN
SIMPLIFIED CHINESE
SLOVAK
SLOVENIAN
SPANISH
SWEDISH
TAMIL
TELUGU
THAI
TRADITIONAL CHINESE
TURKISH
UKRAINIAN
VIETNAMESE
406882
Thanks all OTN Member for ur interest and instant replies..

Now it is quite Clear, that presently ORACLE 9i, doesn't have support for URDU language.

I was reading the Oracle 9i, Release 2 guide and i read about the LOCALE Builder utility.. My confusion is that

- Can i build URDU Language Supported Locale through LOCALE BUIlDER Utility??
Can i make URDU LOCALE through Locale Buider Utility???

I am very worried..
Plz anyone help

Regards
Salman Iqbal
natlangs
Salman,

The NLS_LANGUAGE parameter or the Oracle supported languages are used to determine the language for displaying the Month names (i.e. MONTH and MON format masks) and day of the week names (i.e. DAY and DY) etc. It has no effect of data storage. It does not affect the storage of URDU characters in the database, Unicode is the encoding that you should use for storing all Indic scripts.

Locale Builder does allow you to define new Oracle languages (for defining Month names, day names etc.) Please check out the locale builder section in the globalization support guide for more info.

Nat.

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

Post Details

Locked on Dec 23 2003
Added on Oct 30 2003
5 comments
1,233 views