- changed status to duplicate
[PostgreSQL] Support setting a collation in character columns definition
Issue #2579
resolved
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!
Comments (1)
-
repo owner - Log in to comment
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
#2276is upgraded to cover genericizing all three into sqlalchemy.types.