mysql_collate, the MySQL dialect supports:
('DATA_DIRECTORY', 'INDEX_DIRECTORY',
'DEFAULT_CHARACTER_SET', 'CHARACTER_SET',
'DEFAULT_CHARSET',
'DEFAULT_COLLATE'):
('TABLESPACE', 'DEFAULT CHARACTER SET',
'CHARACTER SET', 'COLLATE'):
On Nov 23, 2010, at 3:21 AM, gentlestone wrote:
> How can I force sqlalchemy to execute this SQL statement?
>
> CREATE TABLE `a_table` (
> `id` int(11) unsigned NOT NULL auto_increment,
> `a_text` text,
> PRIMARY KEY (`ID`)
> ) ENGINE=InnoDB DEFAULT CHARSET=my_custom_charset
> COLLATE=my_custom_collation;
>
> I know there is an option to define table level engine and character
> set but what about table level collation? (Not a specific column level
> collation)
>
> # FIXME COLLATE=my_custom_collation
> sqlalchemy.Table('a_table', metadata, *columns, mysql_engine='InnoDB',
> mysql_charset='pipeliner')
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
