Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Multi-language in one Database
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