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

[17 Mar 2007 14:37] Ehab Amer
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
[22 Mar 2007 13:15] Tonci Grgin
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.
[22 Mar 2007 18:37] Ehab Amer
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
[22 Mar 2007 18:44] Ehab Amer
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.
[23 Mar 2007 12:14] Tonci Grgin
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.
[23 Mar 2007 12:15] Tonci Grgin
-

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

[27 Mar 2007 14:52] Bugs System
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
[27 Mar 2007 14:53] Reggie Burnett
This was a bug in the base connector and is fixed in 5.0.7.
[2 Apr 2007 6:56] MC Brown
A note has been added to the 5.0.7 changelog for C/NET with a note that this affected the VStudio plugin operation.