[PostgreSQL] Support setting a collation in character columns definition

[Former user]

With the MySQL dialect it is currently possible to specify a collation for a VARCHAR column (as well as for TEXT and CHAR columns??).

AFAIK that's not possible with the PostgreSQL dialect. That would be a nice feature to have, as the locale setting is set (in stone) when a Postgres database is created...

I've just seen that someone requested the same feature for the SQLite dialect (bug #2276). So maybe that collation feature could be implemented in a more generic way inside SQLAlchemy?

Thanks a lot!

[Mike Bayer]

This kind of thing becomes generic once the idea is consistently established in enough database backends. When collation support was added, only MySQL supported it. Googling around for PG, here: http://www.postgresql.org/docs/9.1/static/collation.html I see this feature was only added in 9.1 so is very recent.

The trifecta of SQLite, PG, and MySQL certainly pushes this up to a top-level feature. So will close this as a dupe and #2276 is upgraded to cover genericizing all three into sqlalchemy.types.