Hello,
If I recall that correctly, utf8_swedish_ci is the collation to use for
european/western european languages. Those Swedish people think they can
stand for whole Europe... ;)
Not tested my reply, though.
and doesn't work either.
This is the sorting result with utf8_swedish_ci:
+----+-------+
| id | name |
+----+-------+
| 1 | abc |
| 3 | opq |
| 8 | taal |
| 6 | taest |
| 7 | toast |
| 5 | täst |
| 2 | äbc |
| 4 | öpq |
+----+-------+
But instead it should be:
+----+-------+
| id | name |
+----+-------+
| 1 | abc |
| 2 | äbc |
| 4 | öpq |
| 3 | opq |
| 8 | taal |
| 6 | taest |
| 7 | toast |
| 5 | täst |
+----+-------+
Java has been designed for and is working with UTF8 for more than 10
years now. But Mysql still doesn't seem to have any clue about UTF8. All
UTF8 extensions just look like dirty hacks to stuff UTF8 into it
ordinary one-byte-per-character tables without a concept.
Regards
Marten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
