your setup must be wrong if you're on a properly set up utf8 environment it would leave them as they are (of course they are escaped prior to inserting them - but every string is totally the same in the database as it was before)
use utf8_unicode_ci for your tables and make sure the internal encoding of your app is too On 26 Jan., 13:05, Céryl <[email protected]> wrote: > Hi all, > > I have currently developed a new problem in my website. > When storing a name into the database wich contains an apostrophe > ( ' ), it stores this in the DB as ' the ASCII code for it. > (that's Amperand, Poundsign, 39, semicolon in case googlegroups parses > it also) > > Now some of my pages parse this correctly and display the apostrophe, > some display the ASCII code. I can't find what makes it display it > differently on some pages and not on the others... Even escaping it > with a \ just makes it display \' on one page and \$#39 on the other. > > Both get the same data through the same model... Well, it's just > simply the same site, just consistently different per page... Any > clues what might be the problem? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
