Re: Multiple Languages in Oracle ...

Oracle can store different langs.

But if you will store one record in one language and other in another, you have to
implement special column to define in which lang it stored. So you have to have several rows about one product description in every lang.
you can simple filter e.g. only German records.

if you create table userlang (username, lng_id) you can awtomatically choose lang depends on user connected.

create view VL_PRODUCTS as
select * from products p, userlang u where p.lng_id=u.lng_id and u.username=user;

And so on... labels for forms, messages...

Also you can set date/money... formats by ALter session set NLS_... Or in evironment of client site (NLS_LANG and other NLS_...)

Mark

Wim Teuwens <Wim.Teuwens_at_Technum.Be> wrote in message news:7rln39$m1k$1_at_news3.Belgium.EU.net...
> Hi,
>
> We're about to develop an Oracle 8i database.
> Because it's for multiple countries (Poland,US, Germany,Greece,Tsjech, ..)
> text should be available in different languages, e.g. a product
discription.
> Because it's an internet-application, text would be put in by a
webbrowser.
> How do we setup such a database, what type of columns do we have to use ?
> Can Oracle store different 'languages' into the same database ?
> Are there any pitfalls ? Any Tricks ?
>
> Does anyone has some suggestions ? Or maybe links to some webpages for
info
> or books ?
>
> Any help is greatly appriciated.
>
> Wte_at_anaXis.be
>
>
>
>
Received on Tue Sep 14 1999 - 23:49:27 CDT