Re: [firebird-support] Character set ISO8859_1 is not installed

2019-04-03 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2-4-2019 13:37, Bart Friederichs b...@tbwb.nl [firebird-support] wrote:
> I am connecting to a Firebird database through a WSGI setup on Apache, 
> which is in the ISO8859_1 charset. This worked fine before, but after 
> some updates, it broke.
> 
> I connect like this:
> 
> |fdb.connect(dsn=local_copy,user='',password=''< 
> /span>,charset='iso8859_1')|
> 
> which gives me this error:
> 
> |Errorwhileconnecting to database:\n-SQLCODE:-924\n-bad parameters on 
> attach orcreate database\n-CHARACTER SET ISO8859_1 isnotdefined', -924, 
> 335544325|
> 
> When I leave out the |charset| parameter (or set it to |UTF8|), I get 
> this error:
> 
> |Errorwhilepreparing SQL statement:\n-SQLCODE:-204\n-CHARACTER SET IS 
> O8859_1 isnotinstalled', -204, 335544854|
> 
> When connecting to the same database using |isql-fb| or directly from a 
> Python script, it works fine. I checked the config in 
> |/etc/firebird/fbintl.conf|, and ISO8859_1 is defined in there.

As I already mentioned on Stack Overflow, it looks like fbintl support 
is broken on your system. This could mean that libfbintl.so is 
inaccessible or missing.

Which Linux distribution do you use, and how did you install Firebird?

Mark
-- 
Mark Rotteveel


[firebird-support] Character set ISO8859_1 is not installed

2019-04-02 Thread Bart Friederichs b...@tbwb.nl [firebird-support]
I am connecting to a Firebird database through a WSGI setup on Apache,
which is in the ISO8859_1 charset. This worked fine before, but after some
updates, it broke.

I connect like this:

fdb.connect(dsn=local_copy, user='', password='', charset='iso8859_1')

which gives me this error:

Error while connecting to database:\n- SQLCODE: -924\n- bad parameters
on attach or create database\n- CHARACTER SET ISO8859_1 is not
defined', -924, 335544325

When I leave out the charset parameter (or set it to UTF8), I get this
error:

Error while preparing SQL statement:\n- SQLCODE: -204\n- CHARACTER SET
ISO8859_1 is not installed', -204, 335544854

When connecting to the same database using isql-fb or directly from a
Python script, it works fine. I checked the config in
/etc/firebird/fbintl.conf, and ISO8859_1 is defined in there.

Bart Friederichs