Hi, Anyone here using Zope and interbase to access an ISO8859_1 database? I'm using RedHat 7.1, Zope 2.3.3 and InterBaseCS_LI-V6.0.1.tar OpenSource (that's the binary release), python 1.5.2 from the RedHar RPMS and gvibDA-0-9-6. The database I'm trying to access was created, on another machine, with the ISO8859_1 charcter set and it works fine there. If I add the option _default_dpb = { isc_dpb_lc_ctype : 'ISO8859_1' } to the adapter, whenever I try to connect I get the following error:
z=gvib.connect('/usr/local/var/som_db.gdb','sysdba','masterkey') Traceback (innermost last): File "<stdin>", line 1, in ? File "gvib.py", line 130, in connect ib_connect = gvibBase.IBConnect(dsn, user, password, tpb, dpb) gvibExceptions.InternalError: - bad parameters on attach or create database -- CHARACTER SET ISO8859_1 is not defined
If I do not add this option, I can connect but any query using accented charcters get the error:
z.execute("select * from table where field LIKE '%รก%'") z.fetchone() Traceback (innermost last): File "<stdin>", line 1, in ? File "gvibCursor.py", line 265, in fetchone gvibBase.IBSetException(cursor.status) gvibExceptions.DataError: - arithmetic exception, numeric overflow, or string truncation -- Cannot transliterate character between character sets
I get this same error if I try this query on isql. Does anyone know how to get isql to work with the ISO8859_1 charset as well? Do I need to recompile interbase or something? Thanks in advnce, Nuno