Preliminary unicode changeset [2447] broke cx_Oracle

Issue #520 resolved
Former user created an issue

cx_Oracle demands that SQL sent to it be as string, not unicode object. Changes in 2447 made it stop working. Sample exception message:

File "c:\svn\sqlalchemy\lib\sqlalchemy\engine\base.py", line 569, in _execute raise exceptions.SQLError(statement, parameters, e) sqlalchemy.exceptions.SQLError: (TypeError) expecting None or a string u'INSERT INTO cm3_versions (database_version, install_time) VALUES (:database_versi on, :install_time)' {'install_time': datetime.datetime(2007, 3, 28, 13, 27, 14, 444000), 'database_version': 19}

Note the u'...'.

Tested with sqlalchemy from SVN r2453, cx_Oracle version 4.3

Comments (3)

  1. Mike Bayer repo owner

    thanks for keeping on trunk ! try out the change I made in changeset:2455, which I have not yet tested for oracle (regular tests pass). if you look at what its doing, its pretty self-explanatory. feel free to reopen and adjust the change i made if i got it wrong...thanks !

  2. Log in to comment