How do I implement Multi-Lang Sort orders from same database?
From: John Kane <jdkane_at_hotmail.com>
Date: Thu, 22 Aug 2002 10:37:15 -0400
Message-ID: <uG699.6781$xL1.1245943_at_news20.bellglobal.com>
Date: Thu, 22 Aug 2002 10:37:15 -0400
Message-ID: <uG699.6781$xL1.1245943_at_news20.bellglobal.com>
Hi,
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
We have one Oracle database that contains French characters, as well as
numerous other languages.
- 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 Thu Aug 22 2002 - 16:37:15 CEST