Look into using the Unicode type for python unicode values.
http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/types.html?highlight=unicode#sqlalchemy.Unicode On Dec 11, 2008, at 12:01 PM, jo wrote: > > Hi all, > > I'm using SA with cx_Oracle. In some queries it raises the following > error: > > > File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py", > line 581, in _execute_raw > self._execute(context) > File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py", > line 599, in _execute > raise exceptions.SQLError(context.statement, context.parameters, e) > SQLError: (NotSupportedError) Variable_TypeByValue(): unhandled data > type unicode > 'SELECT comune.data_fine AS comune_data_fine, comune.id AS > comune_id, comune.auto_sync_bdn AS comune_auto_sync_bdn, > comune.cod_provincia AS comune_cod_provincia, comune.istat AS > comune_istat, comune.data_inizio AS comune_data_inizio, > comune.cap AS comune_cap, comune.codice_erariale AS > comune_codice_erariale, comune.bdn_id AS comune_bdn_id, > comune.nome AS comune_nome > \nFROM comune > \nWHERE comune.id = :comune_id ORDER BY comune.rowid' {'comune_id': > u'2895'} > > > Someone could help me? > > j > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
