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
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