*From: VeeJay* <[EMAIL PROTECTED]> To: mysql@lists.mysql.com, [EMAIL PROTECTED] Date: Fri, Aug 10, 2007 at 8:19 AM
Hello there I have a problem. When I try to select some names starting with extra alphabets (Å Æ Ø Ä Ö, etc), I simply don't get required results i.e., if I give a select command like: select * from employees where fname LIKE 'Å%'; I get results starting with English alphabet 'A' but not with 'Å'. Which also exist in database. It happens same with Ä... for Ø or Ö, I get results starting with english O... :( Here is the output of database characterset: mysql> SHOW VARIABLES LIKE 'character_set%'; +--------------------------+----------------------------------------+ | Variable_name | Value | +--------------------------+----------------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/local/mysql/share/mysql/charsets/ | +--------------------------+----------------------------------------+ 8 rows in set (0.00 sec) Operating system is FreeBSD 6.2. MySQL 5.0 Another question: Is there any way to optimize the LIKE or is there any fast method to select a column based on starting with a given character? Thanks for your kind help! -- Thanks! BR / vj -------- *From: mysql* <[EMAIL PROTECTED]> To: VeeJay <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Date: Fri, Aug 10, 2007 at 9:07 AM in addition to the correct character-set also set the appropriate collation sequence suomi [Quoted text hidden] -------- *From: VeeJay* <[EMAIL PROTECTED]> To: mysql <[EMAIL PROTECTED]> Date: Fri, Aug 10, 2007 at 5:38 PM Hi Suomi Thanks for your response. But how to set collation sequence? Could you please guide a little? Thanks... VJ [Quoted text hidden] -- Thanks! BR / vj --------
