unicode support

2003-11-14 Thread hory
Quick question I haven't found in the docs. I have a column with unicode (utf8 or ucs2) character set. How can I use a national collation on it? (upper(), lower(), sort order) None of the examples in the docs work... :( -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

unicode order

2003-11-10 Thread hory
Hi, I was trying to use ORDER BY on a unicode field. I can use 2 types of collation: binary and default. Both give wrong results. The binary puts accented letters on the end of the list, the default puts all of them between 'A' and 'B'. What I'd need is central-european collation support for the u