No it's good, all is in utf-8. I become crazy, i don't understand my problem.
The only thing I know is the specials characters froml database appear as a
black square with a question mark.
Thanks for your help!
Jonathan Lebensold wrote:
>
> hmmm... not sure... I would check the collation to make sure its
> utf8_unicode_ci and that the tables are InnoDB / utf8_general_ci... at
> least that's what I've used and its worked.
>
> my 2 cents.
>
> j
>
> On 24-Aug-08, at 11:48 AM, Maxime P wrote:
>
>>
>> Thank you Jonathan and no problem for your french.
>>
>> You can answer me in english.
>>
>> I've already done that but it don't works, i try everything.
>>
>> I put:
>>
>> In my bootstrap:
>> ---------
>> try {
>> $db = Zend_Db::factory($config->db);
>> $db->query("SET NAMES 'utf8'");
>> $db->internalEncoding = 'utf-8';
>> $db->databaseEncoding = 'utf-8';
>> Zend_Db_Table::setDefaultAdapter($db);
>> }
>>
>> ...
>>
>> $view = new Zend_View(array('encoding'=>'UTF-8'));
>> ---------
>>
>>
>> in my layout.phtml
>> <?php header('Content-type: text/html; charset=UTF-8'); ?>
>> <head><meta http-equiv="Content-Type" content="text/html;
>> charset=utf-8"
>> /></head>
>>
>>
>> Only the data from the database appear with errors '?'. I don't
>> understand
>> why? because the charset of the database is utf-8.
>>
>>
>> I think $db->query("SET NAMES 'utf8'"); don't work for all request.
>>
>> Can you help me? Thks!
>>
>>
>>
>>
>>
>>
>> Jonathan Lebensold wrote:
>>>
>>> salut Maxime,
>>>
>>> je m'excuse pour mon français briser...
>>>
>>> il faut que tu ajustes le configuration de caractères avant que tu
>>> faits des transaction avec ton base de données.
>>>
>>> Avec Zend_Db et MySQL, dans ton bootstrap.php ou n'importe quelle
>>> fichier qui comprend ton configuration de Zend_Db, il faut metre "SET
>>> NAMES 'utf8'" comme ça:
>>>
>>> $db = Zend_Db::factory($config->db->adapter, $config_values);
>>> // for Unicode support
>>> $db->query("SET NAMES 'utf8'");
>>> Zend_Db_Table::setDefaultAdapter($db);
>>>
>>> bonne chance,
>>>
>>> j
>>>
>>>
>>>
>>>
>>> On 24-Aug-08, at 9:03 AM, Maxime P wrote:
>>>
>>>>
>>>> Bonjour,
>>>>
>>>> Mon problème se situe au niveau des données qui sont issues de la
>>>> base de
>>>> données et donc les caractères spéciaux s'affichent mal. Peux-tu me
>>>> dire
>>>> comment tu as procédé?
>>>>
>>>> Merci d'avance!
>>>>
>>>> Cordialement,
>>>>
>>>>
>>>>
>>>> quazardous wrote:
>>>>>
>>>>> hi,
>>>>>
>>>>> I m french and I want to use character encoding with zf...
>>>>>
>>>>> So my question is : what's the good stategy between db/input/output
>>>>> components ...
>>>>>
>>>>> => fot database it seams easy :
>>>>>
>>>>> define an internal_encoding and a database_encoding ans subclass
>>>>> Zend_Db_Adapter_Pdo_Mysql (ie for Mysql Pdo) :
>>>>>
>>>>> ----------
>>>>> class Encoding_Db_Adapter_Pdo_Mysql extends
>>>>> Zend_Db_Adapter_Pdo_Mysql
>>>>> {
>>>>> protected $_internalEncoding;
>>>>> protected $_databaseEncoding;
>>>>> ....
>>>>> }
>>>>> ---------
>>>>>
>>>>> overwrite query and fetch functions with mbstring stuff...
>>>>>
>>>>> => for inputs ust subclass zend_filter in the same way.j
>>>>>
>>>>> => but for outputs it's not so simple :
>>>>>
>>>>> using mbstring.encoding_translation On is not very clean :
>>>>> - side border effect on zf implementation (Zend_Cache uses
>>>>> ob_start)
>>>>> - too much server side
>>>>> ...
>>>>>
>>>>> I m thinking about using a Encoding_Dummy_Cache_Frontend_Page
>>>>> class...
>>>>> This class will just use ob_start with a mb_string callback
>>>>> function...
>>>>>
>>>>> And subclassing Zend_Cache_Frontend_Page in
>>>>> Encoding_Cache_Frontend_Page
>>>>> to overwrite the function _flush() with some mbstring stuff....
>>>>>
>>>>>
>>>>> your advise ?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>> --
>>>> View this message in context:
>>>> http://www.nabble.com/Charset-encoding-integration-stategy-in-ZF-%3A-how---tp13611650p19130455.html
>>>> Sent from the Zend Framework mailing list archive at Nabble.com.
>>>>
>>>
>>>
>>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Charset-encoding-integration-stategy-in-ZF-%3A-how---tp13611650p19131634.html
>> Sent from the Zend Framework mailing list archive at Nabble.com.
>>
>
>
>
--
View this message in context:
http://www.nabble.com/Charset-encoding-integration-stategy-in-ZF-%3A-how---tp13611650p19140710.html
Sent from the Zend Framework mailing list archive at Nabble.com.
