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
