MySQL Bugs: #3918: Charset in MySql 4.1.1

Bug #3918	Charset in MySql 4.1.1
Submitted:	27 May 2004 17:16	Modified:	6 Aug 2004 0:04
Reporter:	Reggie Burnett	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:		OS:
Assigned to:	Reggie Burnett	CPU Architecture:	Any

Description:
 I found that the current driver did not support well in
4.1.1.

First of all, it try to get the default character set by
calling "show variables like 'character_set'", in version
4.1.1, this variable is revised into 'character_set_client,
_result etc. Please take a better way to determine the
default charset

Moreover, it parse the SQL inside th method 'SpliteSQL'
in byte. Characters in different encoding may consist of
sql special character, parasing sql in byte level is not a
good way to do so. I have tried to edit the driver myself
how about I have failed. For example, in UTF8 encoding,
chinese character are in 3 bytes and bytes may
contains ', \ etc.

Will it be better if we can provide a setting to alter the
default session charset in the connectionstring? i.e., by
calling SET CHARACTER SET UTF8.

How to repeat:
Unknown

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

This has been fixed.  Thank!