Re: AW: [fw-db] Zend_Db insert and update utf-8 chars

thx, i removed set charset and set names with your source.

all resolved

Uli Wolf wrote:
>
> I've always used UTF-8 like this:
>
> $params = array(
> 'host' => 'localhost',
> 'username' => 'YOURUSERNAME',
> 'password' => 'YOURPASSWORD',
> 'dbname' => 'YOURDATABASE',
> 'driver_options' => array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES
> UTF8;');
> );
> $db = Zend_Db::factory('PDO_MYSQL', $params);
>
> But it's the same as using the Query at first, except, that UTF8 is set
> for lazy-loading. You could try setting the locale for your content, but
> normally you should be fine with UTF8 if converted correctly...
>
>> -----Ursprüngliche Nachricht-----
>> Von: Thasmo [mailto:thasmo@gmail.com]
>> Gesendet: Sonntag, 26. April 2009 16:39
>> An: denadai2
>> Cc: fw-db@lists.zend.com
>> Betreff: Re: [fw-db] Zend_Db insert and update utf-8 chars
>>
>> Maybe try to NOT use '$db->query("SET NAMES UTF8")'.
>>
>> denadai2 schrieb:
>> > I've the same problem... Is there anyone that can help us?
>> >
>> >
>> >
>> > richardjansen wrote:
>> >
>> >> Hi there
>> >>
>> >> My database is MySQL, charset of the db is utf-8. I use PDO. I've
>> done
>> >> $db->query("SET NAMES UTF8"). Now I can read correctly from de
>> database.
>> >> The data in de db is how I want it (utf-8). The charset of de HTML
>> is also
>> >> utf-8.
>> >>
>> >> The problem: I'm trying to insert and update special chars (like é)
>> with
>> >> Zend_Db_Table_Abstract::insert (and update). The inserted data has
>> stopted
>> >> just before the special char. Foo é Bar -> Foo.
>> >>
>> >> Thanks for your comments,
>> >> Richard Jansen
>> >>
>> >>
>> >>
>> >
>> >
>
>
>

--
View this message in context: http://www.nabble.com/Zend_Db-insert-and-update-utf-8-chars-tp21156810p23273876.html
Sent from the Zend DB mailing list archive at Nabble.com.