Ozzy u are right! I had exatly the same problem, (but with user input with a form) and just simply adding
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8;charset=utf-8" /> to the header of the page solved the problem. Thanks again! On Apr 29, 2:09 am, Ozzy <[email protected]> wrote: > Are you sure that the data in the $import[85] is encoded in UTF-8? The > browser can show it correctly, since it selects the correct encoding, > but that does not mean that string is encoded in UTF-8. You can try > forcing the browser to show the page in UTF-8, that should show you > the problem. If you have tried this, I don't know the problem. > > On Apr 25, 5:16 pm, 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 > 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
