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/myodbc?unsub=gcdmo-myodbc@m.gmane.org

charset=XXX is not a valid parameter in connection string >>Re: How to use odbc to save Chines

Hi Chen Jun:

'charset=XXX' is not a valid parameter in connection string, so it will not affect the client encoding.
you can execute a 'SET CHARACTER SET XXX' sql statement to change the client encoding after a database connection is created/established.

Also, you can use ODBC DataSource instead of connection string, i prefer ODBC datas ource because there's an 'Initial Statement' option in MyODBC configuation dialog, you can set it to 'SET CHARACTER SET XXX' so that your application does not need to care about the client encoding.

The client encoding need not be the same as the server encoding. If you web pages are encoded in GB18030/GBK/GB2312, then you need to use GBK as the client encoding.

Wish it can help you.

############
ODBC Á´½Ó×Ö·û´®²¢Ã»ÓÐ charset=XXX ÕâÒ»ÏËùÒÔÕâÑù²»Äܸü¸Ä¿Í»§¶ËµÄ±àÂ룬Äã¿ÉÒÔÔÚÊý¾Ý¿âÁ¬½Ó³É¹¦ ºóÏÈÖ´ÐÐÒ»¸ö SET CHARACTER SET XXX µÄ SQL Óï¾ä£¬ÕâÑù²ÅÄܸü¸ÄÄãµÄ¿Í»§¶Ë±àÂë¡£

Èç¹û»·¾³ÔÊÐíµÄ»°£¬ÎÒÍƼöÄ㻹ÊÇͨ¹ý ODBC Êý¾ÝÔ´À´·ÃÎÊÊý¾Ý¿â£¬ÒòΪ MyODBC Àï¿ÉÒÔÅäÖÃÒ»¸ö Initial Statement µÄÑ¡Ï°Ñ SET CHARACTER SET XXX Óï¾äдÔÚÕâÀï¾ÍÐÐÁË£¬ÄãµÄ³ÌÐòÒ²²»ÓùØÐıàÂëµÄÊÂÇéÁË

»¹ÓоÍÊÇ£º¿Í»§¶Ë±àÂë²»Ò»¶¨·ÇµÃ¸úÊý¾Ý¿â·þÎñÆ÷µÄ±àÂëÒ»Ö£¬¼ÙÉè ÄãµÄ web Ò³Ã涼Óà GB ϵÁбàÂëµÄ»°£¬ÄÇÄãÓ¦¸ÃÓà GBK ×÷Ϊ¿Í»§¶ËµÄ±àÂ룬¶ø²»ÊÇ UTF-8¡£

Ï£ÍûÕâЩÄܶÔÄãÓÐËù°ïÖú¡£


------------------
ÁõÑÐ
2007-11-14

------------------------------------------------------------ -
·¢¼þÈË£ºJun Chen
·¢ËÍÈÕÆÚ£º2007-11-14 12:23:59
ÊÕ¼þÈË£ºmyodbc@lists.mysql.com
³­ËÍ£º
Ö÷Ì⣺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/myodbc?unsub=lovetide@21cn.com


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: How to use odbc to save Chinese into mysql in ASP.NET

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:acgtek@yahoo.com]
> Sent: Tuesday, November 13, 2007 5:57 PM
> To: myodbc@lists.mysql.com
> 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/myodbc?unsub=jerry@gii.co.jp





--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org