Re: UTF-8 collation problem with greek extended characters
Am 05.02.2007 um 18:11 schrieb Chris White: SELECT * FROM tablename WHERE fieldname LIKE BINARY '[greek small eta]' that *should* ( see disclaimer ;) ) give you what you need Yes, it does. I should have also asked for SELECT DISTINCT fieldname ... in the first place, but looking at your answer and asking Google I've already seen that MySQL knows DISTINCT BINARY also. Thanks a million, Chris! -- sven fuchs fon: +49 (58 45) 98 89 58 artweb design fax: +49 (58 45) 98 89 57 breite straße 65www: http://www.artweb-design.de de-29468 bergen mail: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: UTF-8 collation problem with greek extended characters
Sven Fuchs wrote: These characters are stored/retrieved correctly. But they are wrongly regarded the same character by statements like SELECT * FROM tablename WHERE fieldname LIKE '[greek small eta]' The database's character-set is set to "UTF-8 Unicode (utf8)" and the table's and varchar field's collation is set "utf8_unicode_ci". Is there anything I can do to have MySQL distinguish these characters? DISCLAIMER: not tested try something like: SELECT * FROM tablename WHERE fieldname LIKE BINARY '[greek small eta]' that *should* ( see disclaimer ;) ) give you what you need -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
UTF-8 collation problem with greek extended characters
MySQL 4.1.22 seems to treat the following characters as equal (comparing them as varchar values): U+03B7 (206 183) greek small letter eta U+1F75 (225 189 181) greek small letter eta with accent oxia U+1FC4 (225 191 135) greek small letter eta with accent persispomeni and accent ypogegrammenti These characters are stored/retrieved correctly. But they are wrongly regarded the same character by statements like SELECT * FROM tablename WHERE fieldname LIKE '[greek small eta]' The database's character-set is set to "UTF-8 Unicode (utf8)" and the table's and varchar field's collation is set "utf8_unicode_ci". Is there anything I can do to have MySQL distinguish these characters? (mysql --version is Ver 14.7 Distrib 4.1.22, for apple-darwin8.8.1 (i686) using EditLine wrapper) Thanks in advance! -- sven fuchs fon: +49 (58 45) 98 89 58 artweb design fax: +49 (58 45) 98 89 57 breite straße 65www: http://www.artweb-design.de de-29468 bergen mail: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
UTF-8 Collation
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]