On Apr 24, 2008, at 9:45 AM, Saibot wrote:
>
> Thank you for your help. I followed your advice and have overwritten
> the colums with umlauts with ascii-compatible names:
>
> Table('foo', metadata,
> Column(u"someunicodename", key="someasciiname"),
> autoload=True
> )
OK the next step is to set the encoding on your engine to match the
database encoding. the stacktrace here is specifically a result set
coming back to SQLAlchemy which then tries to decode the names within
cursor.description to Python unicode objects - it defaults to
'utf-8'. So create engine as such:
e = create_engine('dialect://myengine', encoding='iso-8859-1')
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
