[Zope-dev] gvibDA problems

[Leonardo Rochael Almeida]

This is a really long shot and I have absolutely no knowledge of=20
Interbase but, are you sure it is 'ISO8859_1'? shouldn't it be 'ISO8859-1=
'?


Nuno Maltez wrote:

> Hi,
>=20
> Anyone here using Zope and interbase to access an ISO8859_1 database?
>=20
> I'm using RedHat 7.1, Zope 2.3.3 and InterBaseCS_LI-V6.0.1.tar=20
> OpenSource (that's the binary release), python 1.5.2
> from the RedHar RPMS and gvibDA-0-9-6.
>=20
> The database I'm trying to access was created, on another machine,
> with the ISO8859_1 charcter set and it works fine there.
>=20
> If I add the option
>=20
> _default_dpb =3D { isc_dpb_lc_ctype : 'ISO8859_1' }
>=20
> to the adapter, whenever I try to connect I get the following error:
>=20
>=20
>>>>z=3Dgvib.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 =3D gvibBase.IBConnect(dsn, user, password, tpb, dpb)
> gvibExceptions.InternalError: - bad parameters on attach or create data=
base=20
> -- CHARACTER SET ISO8859_1 is not defined
>=20
>=20
> If I do not add this option, I can connect but any query using
> accented charcters get the error:
>=20
>=20
>>>>z.execute("select * from table where field LIKE '%=E1%'")
>>>>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=20
> truncation -- Cannot transliterate character between character sets
>=20
>=20
> 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?
>=20
> Do I need to recompile interbase or something?