> Most likely the mysql client is set to use latin-1. To change it from
> Cake add the encoding setting to the config/database.php:
>
> var $default = array(
> 'encoding' => 'utf8', // Convert all character data to UTF-8
> 'driver' => 'mysql',
> 'persistent' => false,
> 'host' => 'localhost',
> 'login' => 'user',
> 'password' => 'password',
> 'database' => 'database_name',
> 'prefix' => '',
> );
>
> The MySQL client converts strings read from the server into the
> encoding used locally. This makes sense because you can mix several
> different storage encodings in a table, but you still want something
> like select * from books return readable data for every column.
I was just about to reply, "Thanks, I just forgot to add that to my
checklist." And then, uh ... realised that encoding is missing from
the DB config. {face-palm} How /very/ embarrassing. It's not like I'm
a beginner to all this. Must be old age, then. ;-)
Thanks for the tip!
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 cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
No comments:
Post a Comment