Re: multilingual sql databases and searching

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