Bug #4101 latin1 client charsets instead utf8 (with server's utf8 default)
Submitted: 11 Jun 2004 10:13 Modified: 16 Jun 2004 10:28
Reporter: Roman Karshiev Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.2alpha OS:Linux (Linux Red Hat 7.3)
Assigned to: CPU Architecture:Any

[11 Jun 2004 10:13] Roman Karshiev
Description:
After upgrade 4.1.1alpha to 4.1.2alpha by source compile with options:
./configure \
    --with-charset=utf8 \
    --with-extra-charsets=all
I have next trouble. My clients (PHP, mnoGoSearch) now try working with latin1 instead utf8 character set.

If I see local variables from phpMyAdmin, I see next:
character set client 	latin1 	utf8 	
character set connection 	latin1 	utf8 	
character set database 	utf8 	utf8 	
character set results 	latin1 	utf8 	
character set server 	utf8 	utf8 	
character set system 	utf8 	utf8 	
character sets dir 	/usr/local/share/mysql/charsets/ 	/usr/local/share/mysql/charsets/ 	
collation connection 	latin1_swedish_ci 	utf8_general_ci 	
collation database 	utf8_general_ci 	utf8_general_ci 	
collation server 	utf8_general_ci 	utf8_general_ci

When I set character set after mysql_connect manually 'SET CHARACTER SET utf8' - all right, I see all utf8 charset.

But I can't added 'SET CHARACTER SET' command to precompiled binaries.

my.cnf contant 'default-character-set = utf8' in all sections.

mysql clent work perfectly!
mysql> show variables;
...
| character_set_client            | utf8                             |
| character_set_connection        | utf8                             |
| character_set_database          | utf8                             |
| character_set_results           | utf8                             |
| character_set_server            | utf8                             |
| character_set_system            | utf8                             |
| character_sets_dir              | /usr/local/share/mysql/charsets/ |
| collation_connection            | utf8_general_ci                  |
| collation_database              | utf8_general_ci                  |
| collation_server                | utf8_general_ci          
...

With 4.1.1alpha with some configs all worked ok.

How to repeat:
SHOW VARIABLES from PHP or C/C++ client
[16 Jun 2004 10:28] Alexander Barkov
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

Additional info: This is a duplicate report with the bug 3990.