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 C&P 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.