[sqlalchemy] How to use collate/charset key words in sqlalchemy?

2012-11-19 Thread junepeach
If I should have a table 'mytable' defined like below in mysql database: CREATE TABLE mytable ( id int(11) NOT NULL AUTO_INCREMENT, fullname varchar(50)collate utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; How can I add the 'collate' clause and CHARSET

Re: [sqlalchemy] How to use collate/charset key words in sqlalchemy?

2012-11-19 Thread Michael Bayer
the table modifiers here are accepted by Table as mysql_name=value, and alembic's create_table accepts these as well. Unfortunately they appear to be extremely under-documented in the SQLAlchemy documentation (see http://docs.sqlalchemy.org/en/rel_0_8/dialects/mysql.html#storage-engines for