>Synopsis: Broken CHARSET support in firebird-server
>Arrival-Date: Tue May 31 14:30:02 GMT 2005
>Originator: Jiri Novak
FreeBSD sulaco.dmz.hq.nostromo.cz 5.4-RELEASE-p1 FreeBSD 5.4-RELEASE-p1 #0: Fri May 13 12:30:37 CEST 2005 email@example.com:/usr/obj/usr/src/sys/SULACO-HQ i386
After upgrading firebird to firebird-client and firebird-server I started to notice strange behavior of firebird-server. It no longer creates locks and logfile in /usr/local/firebird, but directly in /usr/local. It also cannot find security.fdb until moved/linked into /usr/local. Also there seems to be some problem with charset support, so connects from PHP with charset parameter of ibase_connect() supplied fails (with warning, but empty connection). I'd tried other charsets with same result.
I'd also noticed some troubles with interbase.so php4 extension, but reported them separately.
- Deinstall firebird, install firebird-server firebird-client
- Observe log/lockfiles in /usr/local
- Try to connect using charset (ie from PHP) as:
ibase_connect($db, $user, $pass, 'WIN1250')
- You'll get:
Warning: ibase_connect(): bad parameters on attach or create database CHARACTER SET WIN1250 is not defined in /data/www/pub-inc/lib/lib_db.php on line 61