Description of problem: Collation order for columns don't work at all, can't restore database using collation for columns, cant even create a new table using collation orders, nor can execute select statemnts on those columns. Version-Release number of selected component (if applicable): firebird.x86_64,firebird-superserver.x86_64 Version:2.1.4.18393.0 Release:1.fc14 How reproducible: 1.-Open isql-fb 2.-Type: create table xxx (name varchar(32) character set UTF8 collate UNICODE); Actual results: Error: COLLATION UNICODE for CHARACTER SET UTF8 is not defined Expected results: No error. Additional info: rpm from firebirdsql.org works ok. Problem seems to be in version of icu libraries, original firebird rpm use version 3.0 fedora package uses 4 These are from FirebirdSS: ldd /opt/firebird/bin/fbserver |grep icu libicuuc.so.30 => /opt/firebird/lib/libicuuc.so.30 (0x00007fe5e7b24000) libicudata.so.30 => /opt/firebird/lib/libicudata.so.30 (0x00007fe5e78a5000) libicui18n.so.30 => /opt/firebird/lib/libicui18n.so.30 (0x00007fe5e7720000)
The problem is icu > 4.2 (Fedora 14 have icu 4.4) Fedora 13 package with icu 4.2 work without problem I'll check with upstream to find a solution
Same problem exists in Debian, which also uses ICU 4.4
reported upstream http://tracker.firebirdsql.org/browse/CORE-3447
firebird-2.1.4.18393.0-3.fc14 has been submitted as an update for Fedora 14. https://admin.fedoraproject.org/updates/firebird-2.1.4.18393.0-3.fc14
firebird-2.5.0.26074.0-7.fc15 has been submitted as an update for Fedora 15. https://admin.fedoraproject.org/updates/firebird-2.5.0.26074.0-7.fc15
Package firebird-2.1.4.18393.0-3.fc14: * should fix your issue, * was pushed to the Fedora 14 testing repository, * should be available at your local mirror within two days. Update it with: # su -c 'yum update --enablerepo=updates-testing firebird-2.1.4.18393.0-3.fc14' as soon as you are able to. Please go to the following url: https://admin.fedoraproject.org/updates/firebird-2.1.4.18393.0-3.fc14 then log in and leave karma (feedback).
Databases need backup/restore to work properly with this fix.
firebird-2.5.0.26074.0-7.fc15 has been pushed to the Fedora 15 stable repository. If problems still persist, please make note of it in this bug report.
firebird-2.1.4.18393.0-3.fc14 has been pushed to the Fedora 14 stable repository. If problems still persist, please make note of it in this bug report.