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 sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---