[symfony-users] Re: Problems with doctrine:data-load
On Wed, 22 Apr 2009, Gary Rojas wrote: The first three records are quoted but it behaves like quotes no exists because the text is trunked how i say before. Is it possible that PHP or your database doesn't have support for your character set? -- --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: Problems with doctrine:data-load
Thanks to Andrei Dziahel and Eno for your answers. I put this configuration in conf/doctrine/schema.yml # connection: doctrine options: type: INNODB collate: utf8_spanish_ci charset: utf8 and the sql generated for all tables have that options on the CREATE sentence. I test inserting text with phpMyadmin (with this text 'El registro está esperando la aprobación por alguien que tenga las credenciales para hacerlo.') and all text is inserted. I think this say to me that PHP is OK and the database has support for the character set i'm using. Another thing that i did was change the format of data/fitures/ status.yml to utf8 but when i loaded data strange chars appears. I think this is for the codification. After that i changed the condification to ascii (how it was before). At least these chars áéíóú cause that all text don't be inserted. Thanks. On 23 abr, 06:45, Eno symb...@gmail.com wrote: On Wed, 22 Apr 2009, Gary Rojas wrote: The first three records are quoted but it behaves like quotes no exists because the text is trunked how i say before. Is it possible that PHP or your database doesn't have support for your character set? -- --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: Problems with doctrine:data-load
hi. You can also try to enclose descriptions in apostrophes or quotes. 2009/4/22 Gary Rojas gary.r...@gmail.com I'm having a problem with my fixture data. This is a part of data/fixtures/status.yml pltStatus: pltStatus_ina: id: ina name: Inactivo description: El registro ha sido desactivado por alguien que tiene las credenciales para hacerlo pltStatus_pen: id: pen name: Pendiente: description: El registro está esperando la aprobación por alguien que tiene credenciales para hacerlo All requirements were created correctly (BD, models, sql file, insert sql, etc.). The problem is that the description field has non-ascii characters (in this case 'á') and these chars cause that the description text be cutting when one of these non-ascii chars is found. I think i'm making something wrong in the status.yml because the database definition is well defined. I have tested inserting the description text using a client and all text was inserted ok. I was searching information about how to solve this problem and i didn't found anything. Thanks so much --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: Problems with doctrine:data-load
I tried all you said me and follow with the same problem. I'm using Symfony 1.2.5 on Windows I read the chapter about symfony configuration on http://www.symfony-project.org/book/1_2/05-Configuring-Symfony This is my complete status.yml file: # pltStatus: pltStatus_ina: id: ina name: Inactivo description: 'El registro ha sido desactivado por alguien que tiene las credenciales para hacerlo' pltStatus_pen: id: pen: name: Pendiente description: 'El registro está esperando la aprobación por alguien que tenga las credenciales para hacerlo.' pltStatus_act: id: act name: Activo description: 'El registro está activo y podrá ser visto por usuarios que tienen las credenciales para hacerlo.' pltStatus_exp: id: exp name: Expirado description: El registro ha alcanzado su periodo de publicación. Normamente el registro llega a este estado de manera automática. pltStatus_eli: id: eli name: Eliminado description: El registro ha sido eliminado por alguien que tiene las credenciales para hacerlo. pltStatus_fin: id: fin name: Finalizado description: El registro ha sido finalizado. Normalmente el registro llega a este estado por intervención del usuario que lo registro. pltStatus_ven: id: ven name: Vendido description: El registro ha sido vendido. Este estado es usado para definir las ordenes de compra. # The first three records are quoted but it behaves like quotes no exists because the text is trunked how i say before. Thanks in advance On 22 abr, 13:02, Andrei Dziahel trickster...@gmail.com wrote: hi. You can also try to enclose descriptions in apostrophes or quotes. 2009/4/22 Gary Rojas gary.r...@gmail.com I'm having a problem with my fixture data. This is a part of data/fixtures/status.yml pltStatus: pltStatus_ina: id: ina name: Inactivo description: El registro ha sido desactivado por alguien que tiene las credenciales para hacerlo pltStatus_pen: id: pen name: Pendiente: description: El registro está esperando la aprobación por alguien que tiene credenciales para hacerlo All requirements were created correctly (BD, models, sql file, insert sql, etc.). The problem is that the description field has non-ascii characters (in this case 'á') and these chars cause that the description text be cutting when one of these non-ascii chars is found. I think i'm making something wrong in the status.yml because the database definition is well defined. I have tested inserting the description text using a client and all text was inserted ok. I was searching information about how to solve this problem and i didn't found anything. Thanks so much --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---