mysql1253_mysql – COLLATION’utf8_general_ci’对CHARACTER SET’二进制’无效？

mysql> SELECT LOCATE("n","München") COLLATE utf8_general_ci;

ERROR 1253 (42000): COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'binary'

我该如何摆脱这个错误？

我已经尝试过的(复制和粘贴)：

$mysql -u admin -p $DATABASE

Enter password:

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.1.69 Source distribution

Copyright (c) 2000,2013,Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SELECT LOCATE("n","München") COLLATE utf8_general_ci;

ERROR 1253 (42000): COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'binary'

mysql> SET NAMES utf8;

Query OK,0 rows affected (0.00 sec)

mysql> SELECT LOCATE("n","München") COLLATE utf8_general_ci;

ERROR 1253 (42000): COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'binary'

mysql> SELECT LOCATE(_utf8"n",_utf8"München") COLLATE utf8_general_ci;

ERROR 1253 (42000): COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'binary'

mysql> SHOW VARIABLES LIKE "character_set_database";

+------------------------+-------+

| Variable_name | Value |

+------------------------+-------+

| character_set_database | utf8 |

+------------------------+-------+

1 row in set (0.00 sec)