Hello,
I have a question related to DBExpert.
I created a table with DBExpert containing names etc..
Now I would like to sort this table considering german "Umlauts" (i.e. "ä").
Can somebody explain me how this can be done?
Thanks a lot in advance.
Thomas
Open the table in design view and then click on the "Keys" tab.
There you can specify the sorting. The Norwegian alphabet has 3 more letters than
the English and DBExpert handles them correctly.
(If your table has lots of data I suggest that you create a copy of the table and use
that one for testing. I lost a few records when I did some changes to the keys for a
table with lots of data.)
Hello Raiko,
first of all thanks a lot for your reply.
As a beginner in using DBExpert I do not understand what you mean by your posting. Therefor I took two screenshots of the DBExpert window.
What I want is that DBExpert handles "ä" as "ae" for example.
Can you please explain me what I have to do to get this done?
What I did in another case was, using the command "Like". Is it this what you mean?
Again thanks a lot.
Thomas
Hi,
I have not used this in a long time... so I dont remember the answer to the big question this poses. Does it support "foreign" character sets - or allow for custom indexing of such characters?
If not, the (sloppy) workaround is to have a secondary field for that data where you have already turned the accented characters into something else. Such as:
Name: Rämon
NameSort: Raemon
The data gets stored in "Name" and your program then puts the "sortable" spelling in "NameSort" which would then be the field you create a key for and do your searching in.
It also means you have to have a "translation" function to handle user input before searches as well so when someone searches for "Rämon" it translates it into "Raemon" and searches the "NameSort" field instead of the "Name" field.
Then basically, for list creation, you would sort and read by the "NameSort" field, but display the "Name" field instead.
That may be all unnecessary if the db program supports what you are looking for - but again, it's been ages since I played with it.
Rob