Nico Grubert <[EMAIL PROTECTED]> wrote on 22/07/2005 09:06:25: > > Hi there, > > I have a MySQL 4.1 DB running including a database whose character set > is set to utf8. > In the database I have a table "tblmembers" with some records containing > german umlauts. > How do I sort results with german umlauts if the database character set > is set to utf8?
According to http://dev.mysql.com/doc/mysql/en/charset-unicode-sets.html you might achieve the effect you want by setting the collation to utf8_unicode_ci Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]