| Bug #25614 | After connection is closed, and opened again UTF-8 characters are not read well | ||
|---|---|---|---|
| Submitted: | 14 Jan 2007 17:11 | Modified: | 23 Jan 2007 15:34 |
| Reporter: | Tomislav Ivancic | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Connector / NET | Severity: | S2 (Serious) |
| Version: | 1.0.8 (RC) | OS: | Windows (windows xp sp2) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | Close(), Connection, Connector/Net, UTF-8 | ||
[15 Jan 2007 16:54]
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/18125
[15 Jan 2007 16:59]
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/18130
[15 Jan 2007 17:00]
Reggie Burnett
Fixed in 1.0.9 and 5.0.4
[23 Jan 2007 15:34]
MC Brown
A note has been added to the 1.0.9 and 5.0.4 changelogs.
Description: Tested on: MySql version: 5.0.24 Connector/Net 1.0.8 (RC) .Net 2.0 Windows XP SP2 When connection to the database is closed and opened again, or closed and new connection is opened UTF-8 characters are not read well. This problem does not exist on Connector/Net 1.0.7 or Connector/Net 5.0.3 only on Connector/Net 1.0.8 (RC). How to repeat: string conString = "Database=test; Data Source=localhost;" + "User Id=root;Password=;CharSet=utf8"; MySqlConnection con = new MySqlConnection(conString); con.Open(); //Works: MessageBox.Show(new MySqlCommand("SELECT value FROM table1 WHERE id = 1", con).ExecuteScalar().ToString()); con.Close(); con.Open(); //Does not work: MessageBox.Show(new MySqlCommand("SELECT value FROM table1 WHERE id = 1", con).ExecuteScalar().ToString()); con.Close(); MySqlConnection con2 = new MySqlConnection(conString); con2.Open(); //Does not work: MessageBox.Show(new MySqlCommand("SELECT value FROM table1 WHERE id = 1", con2).ExecuteScalar().ToString()); con2.Close();