Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Multi-language in one Database

Re: Multi-language in one Database

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 22 Sep 2003 08:51:24 -0700
Message-ID: <1064245874.712931@yasure>


Zixiong WANG wrote:

>Hi,
>
>Is there in Oracle any native support of multi-language :
>With a same SQL query, I would like to retrieve the same data in a given
>language just by defining a language variable (or something like that) ? for
>exemple : with LANG = EN, my SELECT returns the english version of my data,
>with LANG = FR, it returns the french version.
>
>If no such mecanism exists, do you have any suggestion on the best solution
>? (one column per language ? on table per language ? use of a same view on
>front of tables for switching between language (how about updating in this
>case )?)
>
>Thanks in advance.
>
>

Lots of it. Go to http://tahiti.oracle.com and look up "UTF8".

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Mon Sep 22 2003 - 10:51:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US