Re: How do I implement Multi-Lang Sort orders from same database?

John Kane wrote:

> Hi,
> We have one Oracle database that contains French characters, as well as
> numerous other languages.
>
> Of course the English records that are SORTed appear in the right order
> because they don't contain French accented characters.
> However when we display the French version, the accented characters are not
> sorted how we want them to be. (Notice the first and last entries in the
> following French list -- we want them to appear together.)
>
> How might we specify ordering on a per-language (or per-request basis to the
> Oracle database), instead of changing the whole database over to one charset
> or another?
>
> ----- Sample French Listing Section -----
> República Dominicana
> Roumanie
> Royaume-Uni
> Russie
> Russie (Moscou)
> Russie (Sibérie)
> Russie (Stavropol)
> Russie (Tyumen)
> République dominicaine
> République tchèque
>
> ----- \Sample French Listing Section -----
>
> Thanks.
> -- John

Is the character set UTF8?

Daniel Morgan Received on Thu Aug 22 2002 - 18:00:59 CEST