Yes! I find the error!
It's the function strtolower which make an escape on special character. Use
mb_strtolower().
Thks for your help!
Maxime P wrote:
>
> 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---tp13611650p19145175.html
Sent from the Zend Framework mailing list archive at Nabble.com.
