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#creating-engines

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 at 
http://groups.google.com/group/pylons-discuss?hl=en.

Reply via email to