Data access object incorrect insertion

Hi !

I was trying to insert data using Data Access Object :


$msg = "test €£¥ ";

$query="insert into outbox (`Message`) values ('$msg')";

$connection = Yii::app()->dbtest->createCommand($query)->execute();

However, the message inserted is just "test " without symbols.

I tried the query manually on mysql and work just fine.

Did I miss something here ?

Any help would be appreciated!