Re: Collation problem when used with "SET NAMES"

[Peter Gulutzan]

Changing collation_connection with SET NAMES will affect comparison of

literals.
For example:

mysql> set names utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> select 'Mü' = 'My';
+--------------+
| 'Mü' = 'My' |
+--------------+
| 0 |
+--------------+
1 row in set (0.00 sec)

mysql> set names utf8 collate utf8_swedish_ci;
Query OK, 0 rows affected (0.00 sec)

mysql> select 'Mü' = 'My';
+--------------+
| 'Mü' = 'My' |
+--------------+
| 1 |
+--------------+
1 row in set (0.00 sec)

Your example seems to be selecting from a table.
Therefore the important thing is the column's collation.

Peter Gulutzan
MySQL AB