Plz Help!!! SELECT not working with Å Æ Ø Ä Ö Characters
*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
Plz Help!!! SELECT not working with Å Æ Ø Ä Ö Characters
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
Re: Plz Help!!! SELECT not working with Å Æ Ø Ä Ö Characters
in addition to the correct character-set also set the appropriate collation sequence suomi VeeJay wrote: 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! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
