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 [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
-~----------~----~----~----~------~----~------~--~---