>>>>> "Ole" == Ole Dalgaard <josua@stripped> writes:
Ole> Hi there!
Ole> A friend of mine has developed an alternative Danish sort for mysql.
Ole> The Danish letter å ( å in html) was invented 30-40 years ago to
Ole> replace double a, which had a special pronouncation. Some Danish words are
Ole> still spelled with double a instead of å and according to danish grammar
Ole> they should be sorted equally.
Ole> Currently I can not get it to fail, but there might still be a bug in the
Ole> code. How to test this exhaustingly?
Create table where you in a key field enter a lot of different combinations.
Then check the output for the following queries:
SELECT key_column FROM table_name ORDER BY key_column
SELECT key_column FROM table_name WHERE key_column='X'
-- Run the above for all keys
CHECK TABLE key_column;
If the above works, then there is a good change you don't have any bugs.
Ole> One option could be to add it to mysql as an alternative Danish sort
Ole> (danish2 ?).
That would be ok. Just post us the code...
Ole> BR and thanks for a nice DB