OK, it seems that a bug in doctrine dbal configuration parsing is under review by fabpot. I keep commenting on http://groups.google.com/group/symfony-users/browse_thread/thread/a58464ca7c946a
On May 13, 9:58 am, Christophe COEVOET <s...@notk.org> wrote: > Le 13/05/2011 08:59, davidj a crit : > > > > > > > > > Working on Symfony2 b1 with vendors > > Basic install > > I create an Entity/User in the demo bundle like described in doc/ > > current/book/doctrine/orm.html > > > DBAL / ORM settings are : > > doctrine: > > dbal: > > driver: %database_driver% > > host: %database_host% > > dbname: %database_name% > > user: %database_user% > > password: %database_password% > > charset: UTF-8 > > > orm: > > auto_generate_proxy_classes: %kernel.debug% > > auto_mapping: false > > mappings: > > AcmeDemoBundle: ~ > > > app/console doctrine:create:database OK > > > app/console doctrine:create:schema > > get an error > > [PDOException] SQLSTATE[42000]: Syntax error or access violation: 1115 > > Unknown character set: 'UTF' > > The issue here is that MySQL uses UTF8, not UTF-8.> Changed charset to utf8 > > app/console doctrine:create:schema OK > > > But my table is latin1_swedish_ci. > > > How can I configure DBAL to create utf8 tables ? > > > Thank you. > > > David > > The configured charset is for the connection to the database, not for > the encoding of the tables themselves. > Doctrine does not set any charset for the tables or fields when creating > them so they will use the charset defined at the database level. Go in > PHPMyAdmin, change it to utf8 and you will then get utf8 tables when > creating them. > > -- > Christophe | Stof -- 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 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
