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

Wish I had access to non-English data right now. NLS_SORT should be what you are looking for. Set it in the init.ora or on the session level.

"John Kane" <jdkane_at_hotmail.com> wrote in message news:<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 - 18:23:46 CEST