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 key word in alembic migration 
script?

op.create_table('mytable',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('fullname', sa.String(length=50)),
    sa.PrimaryKeyConstraint('id')
)

Thank you very much!

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/sqlalchemy/-/YfV6pOwsg2QJ.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to