Bug #5759 default character set utf8

• Submitted: 27 Sep 2004 8:59
• Modified: 15 Oct 2004 12:29
• Reporter: bernhard schmidt
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1.4 gamma
• OS: Windows (Windows XP)
• 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