Hi all,
I've got a strange problem on saving data to the database.
i have a made a symfony-task to import a csv file and save the objects to
the database. This works fine.. but whenever a utf8 character comes in, the
data is truncated and only the data before the character is saved to the
database.
For example:
"Totdat hij besluit het roer om te gooien: met diëten en lichaamsbeweging"
becomes "Totdat hij besluit het roer om te gooien: met di"
The import continues without any error message.
When echo the value in the import script i get the full text.. so the
problem is somewhere when doctrine saves it to the database.
$boek = new Boek();
$boek->setDecription($import[85]);
$boek->save()
echo $import[85];
echo $boek->getDescription;
Both display the full text: "Totdat hij besluit het roer om te gooien: met
diëten en lichaamsbeweging"
When i put the text with a manual insert in the database, it saves the
record without a problem. and the $boek->getDescription on the frontend site
shows the full text.
The database is configured with Charset utf-8 and collation utf8_unicode_ci
In my schema.yml i start with: (also tried it without this)
options:
collate: utf8_unicode_ci
charset: utf8
In the ProjectConfiguration.class.php i've added: (also tried it without
this)
public function configureDoctrine(Doctrine_Manager $manager)
{
$manager->setCollate('utf8_unicode_ci');
$manager->setCharset('utf8');
}
and in the settings.yml i've added: (also tried it without this)
all:
charset: utf-8
I'm using:
php: 5.2.13
mysql: 5.1.39
symfony 1.4.4 - doctrine
Is this a bug or have i made a mistake?
thanx in advance for helping me out
Roland
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" 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/symfony-users?hl=en
