oracle unicode

This test programms fails on all codecs.

#!/usr/bin/env python2.5
# -*- coding: utf-8 -*-

from sqlalchemy import *

oracle = 'oracle://user:pass@oracle'

def do_test(uri, dbname, encoding):
    table = Table('testtable', BoundMetaData(uri, encoding=encoding),
        Column('testtable_id', Integer, Sequence('testable_seq'), primary_key=True),
        Column('name', Unicode(20)),
        )

    value = u'Künstler'

    table.drop(checkfirst=True)
    table.create(checkfirst=True)
    table.insert().execute(name=value)
    name = table.select().execute().fetchone().name
    if name == value:
        print '%10s [PASS](PASS)' % dbname
    else:
        print '%10s [FAIL](FAIL)' % dbname
    table.drop(checkfirst=True)

do_test(oracle, 'oracle', 'utf-8')
do_test(oracle, 'oracle', 'utf-16')
do_test(oracle, 'oracle', 'latin-1')

However on the same database I can store latin-1 characters via sql developer. I can also insert them manually into the database (if I use a String column) like:

table.engine.execute("insert into testtable (testtable_id, name) values (1, '%s')" % u'Künstler'.encode('latin-1'))

I see the characters truthfully reflected in sql developer. But I cannot retrieve it out again.

I'm not sure this is sqlalchemys problem, I suspect the culprit here is cx_Oracle or my DBA inexpirience (the lack thereof).

Comments (1)