MySQL Bugs: #27240: Property value characterset not retrieved/fetched in conn wizard

Bug #27240	Property value characterset not retrieved/fetched in conn wizard
Submitted:	17 Mar 2007 14:37	Modified:	2 Apr 2007 6:56
Reporter:	Ehab Amer	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Visual Studio Plugin	Severity:	S2 (Serious)
Version:	1.1.2 & 1.0.2	OS:	Windows (windows)
Assigned to:		CPU Architecture:	Any

Description:
I can't enter arabic data in the tables through the visual studio, they become '???' after I save. but its working correctly if i add it through the MySQL query browser
I think I should change the characterset property in the connection string, but I'm not allowed to.
when I write in a value in the characterset field its not accepted, whatever the value is.
is there anyway to go around this to solve my problem ??

How to repeat:
1- create a MySQL connection
2- click advanced
3- type utf8 (or anything) in the characterset field
4- press enter

Suggested fix:
insert the extra fields in the connection string manually (charset = utf8;) but I dont know where the Visual Studio connections are actually saved or if that is actually possible

Hi Ehab and thanks for your report.

What versions are you using:
 - Server
 - c/NET
 - NET FW
 - VS

From what you described to me, I think the problem might be in VS itself. I will try to find someone to test this for me or some way for me to test it.

dear Tonci Grgin
thanks for ur reply

Server: mysql-5.0.27-win32
connector.Net: mysql-connector-net-5.0.3
DotNet Framework: 2.0
Visual Studio 2005 SP1

the problem could actually be in the visual studio itself that is true, the problem only exists while adding data through accessing the table from the server explorer (the arabic problem) it might be due to the missing parameter in the connection string.
but In code all works well

Sorry I didn't clarify in the last comment.
It works well in code as I've added the parameter "Charset = utf8;", but can't in the server explorer.

Hi Ehab. I think I've found what's wrong.

Looking at the plug-in sources I've found following:
 - Connection details should be kept in file called "VSConfig.xml"
 - "Character set" field in wizard should be drop-down box (changing synopsis) as can be seen in CreateDatabase.cs around ln.255

CharacterSet keyword passed by plug-in is not correct:
MySQLConnectionStringBuilder.cs, 701
                case "character set":
                case "charset":

Raising severity to S2.

-

Attachment: 27240.jpg (image/jpeg, text), 49.89 KiB.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/23024

This was a bug in the base connector and is fixed in 5.0.7.

A note has been added to the 5.0.7 changelog for C/NET with a note that this affected the VStudio plugin operation.