(This is all on Debian unstable, firebird 2.5.2.26540 from the package) It seems firebird is bitten again from changes in ICU.
When built (and linked) with ICU 52.1, Unicode collations don't work, similarly to CORE-3447: $ isql-fb Use CONNECT or CREATE DATABASE to specify a database SQL> create database 'test.fdb'; SQL> create table xxx (name varchar(32) character set UTF8 collate UNICODE); Statement failed, SQLSTATE = 22021 unsuccessful metadata update -XXX -COLLATION UNICODE for CHARACTER SET UTF8 is not installed The problem appears also when restoring from backup and when opening a database which worked with firebird linked to ICU 4.8.1.1. fbintl.conf is not changed. (icu_versions = default) Tracing the process reveals that it is trying to load a library named "libicuuc.so.521.so", while in ICU 52.1 the library is named "libicuuc.so.52.1" with a symlink named "libicuuc.so.52" also available. Comparing traces with the stable package (2.5.2.26540, but built with ICU 4.8.1.1), I noticed that it only opens libicuuc.so.48 in what seems to be the startup linkage resolution (the previous library opened is libc.so.6 and the next is libbsd.so.0). Later on there is no attempt to open libicuuc*. When built with ICU 52.1 there is still an opening of libicuuc.so.52 at startup, however, after doing some work with the database, there are attempts to open libicuuc.so.521.so, which fail. My first idea was to patch the ucTemplate (and other *Template) to only use the MAJOR version component. I'll report back if this works, but there may be something else going on, given that these lookups aren't needed at all when linked with older ICU. -- dam ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
