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

Reply via email to