PDO don't know which is mysql server charset?

From: Date: Fri, 21 May 2010 03:54:54 +0000
Subject: PDO don't know which is mysql server charset?
Groups: php.general 
Request: Send a blank email to php-general+get-305373@lists.php.net to get a copy of this message
hi, everybody! I encountered a problem using the PDO: My mysql charset is utf-8, when using PDO's prepare () and statement’s execute() methods, there is not the correct encoding resultset: $ Statement = $ pdo-> prepare ("SELECT * FROM guests ORDER BY?"); $ Statement-> execute (array ('lname')); while ($ row = $ statement-> fetch (PDO:: FETCH_ASSOC)) ( echo $ row ['fname']. "". $ row ['lname']; ) But when I was make charset_set_results to be gbk, everything was normal: $ Pdo-> exec ('SET character_set_results = gbk'); If PDO don't know which charset is fit to me,it will use default charset(utf-8)?This is really mysql server charset! Anybody help me?Thanks! PS: I am using wamp (php5.3.1) -- cleverpig(Dan) Location: Beijing Address: Room 4018,No.A2 South Avenue Fuxingmen Beijing,P.R.China Zipcode: 100031 MSN: great_liudan@hotmail.com QQ: 149291732 Skype: cleverpigatmatrix Facebook ID:cleverpig Blog: cleverpig.name/dan/ Tags: del.icio.us/cleverpig Twitter: twitter.com/cleverpig 新浪微博: t.sina.com.cn/cleverpig Organization: www.beijing-open-party.org Organ@Facebook: http://www.facebook.com/group.php?gid=8159558294

« previous php.general (#305373) next »