There seem to be a lot of people getting unicode when they want str.
I want unicode, I've tried to force it with the connection
parameters. I get it for the column heading but not the value.
Can anyone explain to me what I'm doing wrong.
Thanks
Neil
In [121]: import sqlalchemy
In [122]: engine = sqlalchemy.create_engine
(oracle_conn_string,convert_unicode=True,assert_unicode=True)
In [123]: conn = engine.connect()
In [124]: r=conn.execute("select location from sc.location1m1 where
location like 'North Sydney%220%'")
In [125]: r.fetchone().items()
Out[125]: [(u'LOCATION', 'North Sydney \xbf Site Code 220')]
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
