I'm switching to MySQL from SQLite in my Pylons app and I get this error during setup-app:
sqlalchemy.exc.InvalidRequestError: VARCHAR requires a length when rendered on MySQL I noticed some tables had simply Unicode without length but also adding length to all Unicode columns the error keeps coming. CREATE TABLE views ( id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(40) NOT NULL, `desc` VARCHAR(80), PRIMARY KEY (id) ) 21-02-11 12:18:30,086 INFO [sqlalchemy.engine.base.Engine.0x...ff6c] [MainThread] () 21-02-11 12:18:30,170 INFO [sqlalchemy.engine.base.Engine.0x...ff6c] [MainThread] COMMIT Traceback (most recent call last): ... File "...python2.6/site-packages/SQLAlchemy-0.6.6-py2.6.egg/ sqlalchemy/dialects/mysql/base.py", line 1520, in visit_VARCHAR raise exc.InvalidRequestError("VARCHAR requires a length when rendered on MySQL") sqlalchemy.exc.InvalidRequestError: VARCHAR requires a length when rendered on MySQL Maybe is `desc` column that's nullable? I'm using: * sqlalchemy 0.6.6 * MySQLdb 1.2.3 * MySQL Ver 14.14 Distrib 5.1.41, Thanks for your support -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@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.