| Paul S. Person 2006-07-24, 6:55 pm |
| On 24 Jul 2006 06:15:08 -0700, "Gerd" <schmittinger@unitech.co.za>
wrote:
>I am implementing a dictionary with German letters i.e. ä, and ü.
>Clarion sorts these at the end of the a and u words.
>What can I do to have them follow alphabetically?
>i.e. have the order Arbeit, ärgern, Axt and NOT Arbeit, Axt,
>ärgern.
This may not be at all what you want, but it works for me ...
I have a database which includes the titles of maps (Fritsch
Wanderkarten 1:50.000) purchased when I was stationed in Germany 30
years ago; some of the titles include umlauted vowels. What I did was
to create a separate field, called "Sorter", in which I put the titles
without the umlauts. Thus
Sorter Word
Arbeit Arbeit
argern ärgern
Axt Axt
You then use Sorter as your Key Field but display Word (or whatever
you call that field) for the user to see. This will solve the problem
stated, but may or may not satisfy any other requirements you may
have. Searching a browse box with an incremental locator, for example,
would have to be done ignoring the umlauts, which may or may not be
acceptable.
--
"I find that a great many things which have been conclusively
demonstrated by the Ancients are unintelligible to the
bulk of the Moderns owing to their ignorance"
|