From: mysql (mysqlayni.com)
Date: Fri Aug 10 2007 - 02:07:19 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]