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
