On 10/14/07, debussy007 <[EMAIL PROTECTED]> wrote:
>
>
> * My MySQL database is UTF-8 encoded,
> * all my source pages are UTF-8 encoded,
> * I have the following meta-tag :
> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
> (I can confirm with FF Web developer Toolbar that the rendered page is
> encoded in utf-8)
> * I added $this->view->setEncoding('UTF-8'); in the predispatch method
> inherited by all my controllers,
>
> But when I want to display the list of countries I have in my MySQL DB,
> I still have those weird characters. E.g. for country "Côte d'Ivoire"
> I cannot see the letter ô but a weird character instead.
Even if the DB is set to use UTF-8 you can still put invalid UTF-8 in
string fields. If you put gargbage in you get garbage out. That will
happen if, for example, the form used to submit the data was not
rendered using UTF-8. Meaning, at the time you submitted the data you
application didn't handle UTF-8. Fix your app, delete those records
and try again.
Mike
--
Michael B Allen
PHP Active Directory SPNEGO SSO
http://www.ioplex.com/
