RE: How to use odbc to save Chinese into mysql in ASP.NET
"Jerry Schwartz" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
3.5x versions of ODBC can not handle Chinese characters. I had to switch to the 5.x series, and then I was able to work with Chinese characters. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -----Original Message----- > From: Jun Chen [mailto:[email protected]] > Sent: Tuesday, November 13, 2007 5:57 PM > To: [email protected] > Subject: How to use odbc to save Chinese into mysql in ASP.NET > > Hello all, > > I added utf8 as character set in odbc connection > string. The odbc driver version is 3.51 and mysql > 5.0.x. The problem is that the saved Chinese > characters in the table were displayed as ???? and can > not be read. Here is the connection string. > > Driver={MySQL ODBC 3.51 > Driver};database=dbname;option=0;port=3306;server=localhost;uid=userid; > charset=UTF8 > > However the Chinese text saved through mysql Query gui > interface can be displayed correctly. The mysql > database was created with character set uft8. > > Is there anyone who knows where is the problem? > > Thanks. > -Jun C. > > -- > MySQL ODBC Mailing List > For list archives: http://lists.mysql.com/myodbc > To unsubscribe: http://lists.mysql.com/[email protected] -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]