Comments on: Zend_Db: utf8 query string gets inserted as non-utf8 http://www.qc4blog.com/?p=781 Just another WordPress weblog Tue, 31 Aug 2010 14:20:40 +0000 hourly 1 http://wordpress.org/?v=3.0.1 By: Mat Dodgson http://www.qc4blog.com/?p=781&cpage=1#comment-538 Mat Dodgson Wed, 16 Jun 2010 08:41:00 +0000 http://www.qc4blog.com/?p=781#comment-538 You are my hero! I just spent an hour trying to track this problem down. The utf-8 gets double encoded if you don't set the charset for zend_db to utf-8. So you see the utf-8 escape characters in places like mysql workbench, and in my browser output. Then I grab it and paste it into another program and it gets automatically converted so it looks fine! Thanks so much for this tip! You are my hero! I just spent an hour trying to track this problem down.

The utf-8 gets double encoded if you don’t set the charset for zend_db to utf-8. So you see the utf-8 escape characters in places like mysql workbench, and in my browser output. Then I grab it and paste it into another program and it gets automatically converted so it looks fine!

Thanks so much for this tip!

]]>