« PHP and EOF
Working with arrays in PHP (part i) »

Cakephp, mysql and utf8 problem

Cakephp rocks. I just stared making a new site with cakephp and I already had a problem. The mysql encoding did not work properly for my language (greek). I made my database using utf8_unicode_ci but certain character appear wrong.
This is the solution:

Create a new file app_model.php, place it in your app folder. Put the following contents in the file:

PLAIN TEXT
PHP:
  1. class AppModel extends Model
  2. {
  3. function __construct($id=false, $table=null, $ds=null)
  4. {
  5. parent::__construct($id, $table, $ds);
  6. $this->execute( "SET NAMES 'UTF8'" );
  7. }
  8. }

if you are working with scaffolding, put this line in your cake/libs/view/templates/layouts/default.thtml:

PLAIN TEXT
PHP:
  1. echo $html->charset('UTF-8');

This info comes from: http://www.get-the-answer.info/comments.php?DiscussionID=5&page=1

This entry was posted on Friday, September 8th, 2006 at 10:45 pm and is filed under cakephp, mysql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.