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: multilingual sql databases and searching

Re: multilingual sql databases and searching

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Thu, 17 Jan 2002 14:15:18 +0000
Message-ID: <3C46DC76.8139FE06@exesolutions.com>


Make the instance language UTF8.

Daniel Morgan

garry wiseman wrote:

> Hi,
>
> I wish to store large amounts of copy in an Oracle database, that copy
> being in several different languages, e.g. French, Russian, Japanese.
> How can I do this in Oracle 8i or 9i? How do I setup the tables, what
> string types?
>
> I would then like to do two kinds of searching on this data:
> (1) Case-insensitive: so I search on "food", and the search will find
> "FooD", fOOd", etc.
> (2) Diacritic-insensitive: so I search on "food", and the search will
> find all instances of data with "food" in regardless of accents or
> other such characters.
>
> Can anyone help me with how to setup such searches? Particularly the
> diacritic-insensitive searching?
> Finally - supposing I had 2-3 such databases, how could I search all
> 2-3 simultaneously?
>
> Many thanks,
> Garry.
Received on Thu Jan 17 2002 - 08:15:18 CST

Original text of this message

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