Bug #5759 default character set utf8
Submitted: 27 Sep 2004 8:59 Modified: 15 Oct 2004 12:29
Reporter: bernhard schmidt Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.4 gamma OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[27 Sep 2004 8:59] bernhard schmidt
Description:
hi 

setting the the variable default-character-set=utf8 in my.ini does not change the default character sets of clients. i.e. the variables character_set_client, character_set_connection, character_set_results, etc. The statement SET NAMES utf8 works fine, but i prefer to setting the database to my defaults.

the server used is mysqld-max.

best regards
benny

How to repeat:
set the default-character-set = utf8 in the my.ini and look at the variables.
[15 Oct 2004 12:29] MySQL Verification Team
Hi,

Thank you for the report, but I wasn't able to repeat it.

[mysql]
default-character-set=utf8

or

[client]
default-character-set=utf8

works fine for me.
[15 Oct 2004 15:29] bernhard schmidt
hi

try the following:
-  set the default character set.
- use navicat or another sql query tool, set the character set to utf8
- use an sql statement that uses AES_ENCRYPT() or AES_DECRYPT()
- you will get an error that latin1 and utf8 charsets can not be mixed.

best regards
benny