some things to try: -upgrade to php 5.2.4, it's a minimum for Symfony 1.4 -use mb_detect_encoding() and mb_check_encoding to verify the string you're trying to save is valid UTF-8 -there may be an error generated, but it's being suppressed somewhere with an '@', check all log files -have you tested other strings to verify that it's always UTF-8 characters that causes the issue? -try changing the field type in mysql from varchar to something else, and check the length. Sometimes mysql will truncate data with no warning. -you mentioned being able to insert with a SQL with no problems, can you do the same thing in PHP with a raw SQL call? To verify if it really is a Doctrine issue.
Kris On Apr 25, 10: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] > For more options, visit this group > athttp://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
