- changed milestone to 0.7.xx
COLLATE within TEXT, VARCHAR in CREATE TABLE now supported by PG, SQlite, MySQL
Issue #2276
resolved
There seems to be no way to get sqlalchemy to generate DDL setting a default collation for a column (a la MySQL). SQLite supports CREATE TABLE (column TEXT COLLATE <collation>).
I would hope for Column(String(collation='blah')) but even Column(sqlalchemy.TEXT(collation='blah')) would be nice.
Comments (7)
-
repo owner -
Account Deleted Thank you!
I used something very similar (I made it so length was optional), and this seems to work for us.
Cheers.
-
repo owner - changed title to COLLATE within TEXT, VARCHAR in CREATE TABLE now supported by PG, SQlite, MySQL
- changed component to sql
- changed milestone to 0.8.0
see also
#2579. -
repo owner -
repo owner sqlite: section 6.2 in http://www.sqlite.org/datatype3.html
-
repo owner - changed status to resolved
-
repo owner - removed milestone
Removing milestone: 0.8.0b1 (automated comment)
- Log in to comment
Here's a workaround for now: