Re: Select statement with town Polish characters

[Rick James]

C4B9 agrees with what you are getting, but not with what you want:
http://www.fileformat.info/info/unicode/char/0139/index.htm
C581 seems to be the desired first letter:
http://www.fileformat.info/info/unicode/char/0141/index.htm

This says that the characters went _in_ incorrectly. Now to figure out what caused that.

What do you get when doing the first SHOW?

mysql> SHOW VARIABLES LIKE 'char%';
+--------------------------+-----------------------------------------------+
| Variable_name            | Value                                         |
+--------------------------+-----------------------------------------------+
| character_set_client     | latin1                                        |
| character_set_connection | latin1                                        |
| character_set_database   | utf8                                          |
| character_set_filesystem | binary                                        |
| character_set_results    | latin1                                        |
| character_set_server     | utf8                                          |
| character_set_system     | utf8                                          |
| character_sets_dir       | c:\wamp\bin\mysql\mysql5.1.30\share\charsets\ |
+--------------------------+-----------------------------------------------+
8 rows in set (0.00 sec)

mysql> SET NAMES utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW VARIABLES LIKE 'char%';
+--------------------------+-----------------------------------------------+
| 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       | c:\wamp\bin\mysql\mysql5.1.30\share\charsets\ |
+--------------------------+-----------------------------------------------+

After doing SET NAMES, what do you get with the SELECT in the previous post?