Hi, I recently tried MySQL 4.1.1-alpha in order to get proper UTF-8 support. I need to be able to order on a utf8 text field. Accented characters should (broadly) be treated as though they were not accented for ordering purposes.
Many of the european charsets (eg German) seem to have special collations which follow the rules of the language. I suspect the Unicode Collation Algorithm should be a good approximation to what I need but while the manual says it's there for ucs2 (not utf8) it appears not to be. Anyway, is it be possible to create a custom collation? For now, I've ended up replicating the data with unaccented chars in order to have a column to order on. It's a solution for now, but it's hardly ideal. Thanks Gavin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
