On Feb 10, 2010, at 5:04 PM, Christoph Burgmer wrote:
Having collations on a per-column basis in MySQL and SQLite, I'd like
to specify the collation when creating tables/views. I have been
trying google and source for some hours now, and it seems there's just
no way to handle it easily with SA.
MySQL has support via private VARCHAR, but SQLite has nothing similar.
Generic support is absent.
Could a simple CP of this functionality give SQLite similar support?
I'd file a patch then.
Is there any other way to select a collation via SA, either globally,
or via text() or similar?
I'd hate to completly rewrite the CREATE TABLE statements.
if SQLite supports a COLLATE syntax, then sure we can accept patches for 0.6
/trunk.
If you want instant gratification on sqlite just build yourself a
UserDefinedType for now (again 0.6/trunk).
-Christoph
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
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 sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
