multilingual sql databases and searching

From: garry wiseman <garryw_wiseman_99_at_hotmail.com>
Date: 17 Jan 2002 07:00:54 -0800
Message-ID: <b4a1bf07.0201170700.76bcc203@posting.google.com>

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 - 09:00:54 CST