On Sun, Mar 13, 2011 at 11:57 AM, Chris <[email protected]> wrote: > Hi there, > > I've been a little bit messy about the charset I am actually using in > my application. Now, I decided on using uft8 and I set it in: > > - my default view (for meta-data and html-header) > - core.php (App.encoding) > - database.php (encoding) > > I am pretty sure that my mysql database is not really straightforward > utf8, there are still some columns with latin1. This needs to be > fixed. > > Now, when I see the sql dump it says: > > SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE > COLLATION_NAME= 'latin1_swedish_ci'; > > For me that looks like Cake still does not understand that I want to > use utf8. Is there something else that I could do or do I get this > message because my database is all messed up and Cake somehow detects > it is still latin1?
That's not Cake. For reasons not understood, latin1_swedish_ci is what MySQL defaults to. If you google "latin1_swedish_ci" you'll find that an awful lot of people get tripped up on this. Adding "utf8" should get you info about converting the table (if not the DB). -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
