Hi Gabriel, Thank you for your response. I use fopen to read the csv file. When i output the value before $boek->setDecription($import[85]); i get the full string without problems...
On 29 apr, 06:56, pghoratiu <[email protected]> wrote: > Hi! > > I don't think this has anything to do with Doctrine but with the > handling of UTF-8 strings by the CSV parser. > What class/library do you use for that? > > Display the values before: > $boek->setDecription($import[85]); > and you will see them truncated already. > > Best regards, > > gabriel > > On Apr 25, 5:16 pm,RolandCremer <[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- Tekst uit > oorspronkelijk bericht niet weergeven - > > - Tekst uit oorspronkelijk bericht weergeven - -- 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
