COLLATE within TEXT, VARCHAR in CREATE TABLE now supported by PG, SQlite, MySQL

[Former user]

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.

[Mike Bayer]

Here's a workaround for now:

from sqlalchemy import VARCHAR
from sqlalchemy.ext.compiler import compiles

class SQLiteString(VARCHAR):
    def __init__(self, length, collation=None):
        super(VARCHAR, self).__init__(length)
        self.collation = collation

@compiles(SQLiteString)
def _varchar(element, compiler, **kw):
    length = element.length
    collation = element.collation
    if collation:
        return "VARCHAR(%d) COLLATE %s" % (length, collation)
    else:
        return "VARCHAR(%d)" % length

[Former user]

Thank you!

I used something very similar (I made it so length was optional), and this seems to work for us.

Cheers.

[Mike Bayer]

see also #2579.

[Mike Bayer]

that is, http://www.postgresql.org/docs/9.1/static/collation.html

[Mike Bayer]

sqlite: section 6.2 in http://www.sqlite.org/datatype3.html

[Mike Bayer]

084b559b44bba73becc7e7fa7636d4c5ac99bb55

[Mike Bayer]

Removing milestone: 0.8.0b1 (automated comment)