Please ignore this issue, searched for all Unicode but forgot I also
used a String for a column...
It works flawlessly, I apologize.
On Feb 21, 12:40 pm, neurino <neur...@gmail.com> wrote:
> 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.
