Need help!
SQL Alchemy: 0.6.8
cx_Oracle: 5.1.1
Red-had Linux
Oracle 11gR2, NLS_CHARACTERSET AL32UTF8
Simple Queries like
SELECT events.source_name AS events_source_name
FROM events
WHERE events.source_mac_id = :source_mac_id_1
2012-02-15 10:07:13,061 INFO sqlalchemy.engine.base.Engine.0x...9410
{'source_mac_id_1': u'991111111111A'}
Bind Variables has a 'u' prefixed that causes Oracle to do full TS as
it uses SYS_OP_C2C to do conversion and ignores the index on columns.
class Event(Base):
'''
'''
__tablename__ = "events"
source_name = Column(BigInteger)
source_mac_id = Column(String(128))
......
Tried all settings on engine connect side and also changing as below,
still no help
import os
os.environ["NLS_LANG"]="AMERICAN_AMERICA.AL32UTF8"
import cx_Oracle
Can we get rid of the 'u' being prefixed to Python strings (note that
I am not using Unicode as Object definiation but String, why is it
getting there.
Changing DDL to be NVARCHAR2 is another option on table but we would
like to see if that is recommended??
Regards
Harish Tejwani
--
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.
