Re: Multi-language searches

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 24 Nov 2000 08:39:59 +0100
Message-ID: <8vm9h7$4sl0n$7_at_ID-62141.news.dfncis.de>


This is a database design issue.
You'll need to include a language column in all relevant tables, and keep track of the users native language and/or use his NLS settings in your code to query the relevant records only.
IMO, creating multiple databases for this purpose is one of the safest routes to hell.

Hth,

Sybrand Bakker, Oracle DBA

"NHuckle" <nhuckle_at_aol.com> wrote in message news:20001123181718.10400.00000176_at_ng-fm1.aol.com...
> Hi
>
> I want to set-up a website that uses a graphic database that is linked to
> text-based records (narratives) in several languages. I want the user to
 be
> able to search the database in the native language (be it English, French,
> Japanese etc), but maintain the one copy of the graphic database.
>
> Can this be done inside one Oracle installation, or would multiple servers
 be
> required to hold the text-based databases in their native langauage?
>
> Hopefully I've explained this clearly enough!
>
> Many thanks in advance.
>
> Neil
Received on Fri Nov 24 2000 - 08:39:59 CET

Original text of this message