It was as near as I could remember. There are others where firefox shows playing cards instead of kanji etc.
With this project, I went down that path of changing everything to utf8 including my cat my wife my kids and my underpants. It worked in the end. What nobody emphasizes, though, is that the mysql connection is utf8 whereas everything else is utf-8 -- BIG difference. On 30 Maig, 18:26, "b logica" <[EMAIL PROTECTED]> wrote: > > [EMAIL PROTECTED] > > Is that an actual example? That's not escaped at all. It appears to me > to be the result of MySQL's circus-from-hell when working with UTF-8 > strings. Search online for "mysql utf8" and you'll get *a lot* of hits > about this. One needs to ensure that: > > a) the client connection (Cake) tells MySQL to use UTF-8 (database.php); > b) the database was created with UTF-8 encoding (DEFAULT CHARACTER SET); > c) the data was originally inserted as UTF-8 (PHPMyAdmin, i'm looking at > you!); > d) Cake is serving the pages as UTF-8 > > Depending on one's access to the database in question c can be > somewhat of a pain in the arse to figure out. For instance, PHPMyAdmin > might be part of the problem. If you're using that, check the headers > that the server is sending and then check the source to inspect how > the form is being sent back to the server. I can't remember where I > found it, but there is a configuration option for PHPMyAdmin to handle > everything as UTF-8. > > If you're using any text files to insert the data, make sure they > begin with "SET NAMES 'utf8';" > > If you can, connect to the database through a terminal and have a look > at some of these values (the exact ones you're seeing this problem > with). > > On Fri, May 30, 2008 at 10:20 AM, leo <[EMAIL PROTECTED]> wrote: > > > On 30 Maig, 16:06, "David C. Zentgraf" <[EMAIL PROTECTED]> wrote: > >> If you keep everything UTF-8 from start to finish you actually > >> shouldn't have this problem. > > > On this project, everything is UTF-8 including db etc. That solved the > > problem, but on an earlier project we had to use iso-8859-1. It was > > the only way to get the rss feed displaying properly. On the project, > > the db was, historically, latin1-spanish and I didn't want to change > > it. > > > Having said all that, there are still occasions when not-escaping is > > required, for instance when html entities are stored in po files. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
