HI, I'm having an issues with my queries using extended characters with the Zend Framework and Postgres.
I'm using: - Postgres 8.1 - Zend Framework 9.0 - PHP 5 - Linux (Ubuntu)/Apache My problem seems to be with in the Zend_Db layer. My queries are not accepting extended characters (such as 'é' or 'ç'). PHP displays the characters with a straight print(). I can manually insert extended characters into the Postgres DB via a command prompt and they are inserted and can be retrieved properly. But any time I try to query the DB via the Zend_DB/Db_Table_Abstract classes my data is comes back as unencoded (\u00c3\u00a9). I have tried extending the class and using PHP functions to encode the data, with no success. Digging through the documentation revealed users with similar issues, but no solid solutions (my DB already supports UTF-8, so 'SET NAMES utf8' did not work). Can anyone point me in the right direction? thanks! -- View this message in context: http://www.nabble.com/Zend_Db-Postgres-UTF-8-issue-tf3811632s16154.html#a10788897 Sent from the Zend Framework mailing list archive at Nabble.com.
