Thanks guys. I am using SQLAlchemy 0.6. Just never seen that error before....or should I say having fixed so many issues so far this one caught my eye.
Cheers, garyc On May 1, 1:49 am, Mike Orr <[email protected]> wrote: > On Fri, Apr 30, 2010 at 4:18 PM, cd34 <[email protected]> wrote: > > Are you connecting to a mysql server and processing data from > > sqlalchemy on your page? > > > add > > > ?use_unicode=1&charset=utf8 > > > to your sqlalchemy url: > > > sqlalchemy.url = > > mysql://username:passw...@localhost/databasename?use_unicode=1&charset=utf8 > > > I think that is the condition that generated a similar error for me. > > I think convert_unicode is recommended over this so that SQLAlchemy > can do the conversion in a database-neutral manner. use_unicode is > specific to MySQL. > > create_engine(dburl, convert_unicode=True) > > http://www.sqlalchemy.org/docs/reference/sqlalchemy/connections.html#... > > Also note that SQLAlchemy 0.6 has support for native Unicode in some > DBAPI engines. > > http://www.sqlalchemy.org/trac/wiki/06Migration#NativeUnicodeMode > > -- > Mike Orr <[email protected]> > > -- > You received this message because you are subscribed to the Google Groups > "pylons-discuss" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group > athttp://groups.google.com/group/pylons-discuss?hl=en. -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en.
