Subject "Unable to determine field precison from system tables"
Author Hamish Moffatt
I've just upgraded my Debian Linux system to the new release (stretch/9)
and now I'm getting the following error when accessing a db from Python,
using either fdb (1.6.1) or the old kinterbasdb (3.3.0).


Unable to determine field precison from system tables:

Dynamic SQL Error

SQL error code = -303

Implementation of text subtype 114 not located.


The query is simply "select version_num from g_version" and the column
in question is an int. I can run this query in isql just fine.


My Firebird server is 2.5, but with the system upgrade I got the new
client library version 3.0.1 (Debian's full version number for it is
3.0.1.32609.ds4-14).

If I downgrade the libfbclient2 package back to 2.5.6, the query succeeds.


The subtype number is sometimes 114 and sometimes 132.


Do I need to stick with the old fbclient library, or is there some I
can/need to do to make this work? I have no plans to upgrade my server
to Firebird 3 yet.



Thanks

Hamish