Re: Multi-language searches
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