Going from the line number in your exception that would be because your columns are of type String. Change the columns to Unicode and it should solve your problem.
foo_table = Table('foo', metadata, Column('id', Integer, primary_key=True), Column('bar', Unicode(255)) ) On 12/14/06, jose <[EMAIL PROTECTED]> wrote: > > Hi all, > > I'm trying to insert UTF8 characters (like this: perchè) > in PostgreSQL but... > > > File "build/bdist.linux-i686/egg/sqlalchemy/orm/attributes.py", line 589, > in __init__ > File "build/bdist.linux-i686/egg/sqlalchemy/orm/attributes.py", line 51, in > is_equal > File "build/bdist.linux-i686/egg/sqlalchemy/orm/strategies.py", line 30, in > <lambda> > File "build/bdist.linux-i686/egg/sqlalchemy/types.py", line 179, in > compare_values > UnicodeDecodeError: 'ascii' codec can't decode byte 0xc2 in position 12: > ordinal not in range(128) > > jo > > > > > > > -- Lee McFadden blog: http://www.splee.co.uk work: http://fireflisystems.com skype: fireflisystems --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---