MySQL table options with spaces difficult to pass.

[Former user]

In order to set the character set on a table you must write:

table = Table(table_name, metadata,
    **{'mysql_character set':'UTF8'}
)

I believe this could be alleviated by replacing underscores in option names with spaces. I have attached a patch to do just that.

[jek]

The CHARSET synonym for CHARACTER SET is the easy way to specify the charset.

_ is the usual separator for words in mysql table options (AUTO_INCREMENT, ROW_FORMAT, DATA_DIRECTORY, etc.), so that translation wouldn't fly. The only other CREATE TABLE option with spaces I'm aware of is 'TABLESPACE ... STORAGE DISK' which IMHO does not need to be easy to specify in Python DDL.