How to use odbc to save Chinese into mysql in ASP.NET
Jun Chen <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
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]