[sqlalchemy] VARCHAR requires a length when rendered on MySQL

[neurino]

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.