charset=XXX is not a valid parameter in connection string >>Re: How to use odbc to save Chinese into mysql in ASP.NET
"刘研" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
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 朵欢浜猴[email protected] 锛 涓婚锛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]