unicode

MySQL upgrade and unicode issues

Tagged in

A few days ago I upgraded/emerged MySQL installation on my Unixshell Gentoo box from 4.1.14 to 4.1.19. As it emerges, it also replaced the default configuration file and now uses utf8 as the default encoding to database and client libraries. I also re-emerged dev-lang/php-5.1.4, and it turned out all my unicode on PHP sites are broken! PHP pulls junks out from the database and can’t display them. Meanwhile, anything unicode you put in there becomes a series of question marks ???? in the rendered page.