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

From: John Kane <jdkane_at_hotmail.com>
Date: Fri, 23 Aug 2002 19:48:37 -0400
Message-ID: <qRz99.8764$xL1.1598484_at_news20.bellglobal.com>


Yes, the charset is UTF-8.

--John

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3D650AAB.28D24343_at_exesolutions.com...
>
> Is the character set UTF8?
>
> Daniel Morgan
>

> 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
Received on Sat Aug 24 2002 - 01:48:37 CEST

Original text of this message