Michael Bayer ha scritto:
> Look into using the Unicode type for python unicode values.
>
> http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/types.html?highlight=unicode#sqlalchemy.Unicode
>
This is the 0.5 documentation
I'm using SQLAlchemy version 0.3.10.
and cx_Oracle 4.3.1
Seems cx_Oracle isn't able to convert unicode values into integer.
Take a look:
In [32]: print Azienda.get(1).azienda_id
1
In [33]: print Azienda.id(u'1').azienda_id
SQLError: (NotSupportedError) Variable_TypeByValue(): unhandled data
type unicode 'SELECT azienda.id AS azienda_id \nFROM azienda \nWHERE
azienda.id = :azienda_id ORDER BY azienda.rowid' {'azienda_id': u'1'}
j
>
> 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
-~----------~----~----~----~------~----~------~--~---
