Explore html_entities for this...I'll try look ur problem in detail later
On Sun, Apr 25, 2010 at 7:16 AM, Roland Cremer <[email protected]>wrote:
> 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]<symfony-users%[email protected]>
> For more options, visit this group at
> http://groups.google.com/group/symfony-users?hl=en
>
--
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
