Firebird not using the right ICU library, fixed in Debian, please sync

[Kaf]

When querying the database, returns the error: COLLATION UNICODE_CI_AI for CHARACTER SET UTF8 is not installed. This is a ubuntu package problem, not associating the right ICU lib for firebird.

ProblemType: Bug
DistroRelease: Ubuntu 14.04
Package: firebird2.5-super 2.5.2.26540.ds4-8ubuntu2
ProcVersionSignature: Ubuntu 3.12.0-7.15-generic 3.12.4
Uname: Linux 3.12.0-7-generic i686
ApportVersion: 2.12.7-0ubuntu6
Architecture: i386
Date: Wed Jan 8 14:11:48 2014
ProcEnviron:
 LANGUAGE=pt:pt_BR:en
 TERM=xterm
 PATH=(custom, no user)
 LANG=pt_PT.UTF-8
 SHELL=/bin/bash
SourcePackage: firebird2.5
UpgradeStatus: Upgraded to trusty on 2014-01-05 (2 days ago)

[Kaf (peixinhosdalua)]

It appears that this is fixed in Debian:

http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=732000

[Popa Adrian Marius (mapopa)]

It's fixed in Debian

http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=732000

Ubuntu package needs a sync request with package from debian jessie

http://ftp-master.metadata.debian.org/changelogs//main/f/firebird2.5/firebird2.5_2.5.2.26540.ds4-9_changelog

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Logan Rosen (logan)]

xnox, can you please merge or sync as the TIL?

[Popa Adrian Marius (mapopa)]

A few patches are needed (already applied in debian package) check the log for icu related changes

http://anonscm.debian.org/gitweb/?p=pkg-firebird/2.5.git;a=summary

A simple rebuild is not enough with new
ICU library

[Launchpad Janitor (janitor)]

This bug was fixed in the package firebird2.5 - 2.5.2.26540.ds4-9ubuntu1

---------------
firebird2.5 (2.5.2.26540.ds4-9ubuntu1) trusty; urgency=medium

  * Merge from Debian, remaining changes (LP: #1267128):
    - Add ARM64 platform support.

firebird2.5 (2.5.2.26540.ds4-9) unstable; urgency=medium

  * add patch fixing ICU symbol finding / library loading with ICU 52.1
    Closes: #732000 -- Unicode collations not available with ICU 52.1
 -- Dimitri John Ledkov <email address hidden> Fri, 28 Feb 2014 10:06:16 +0000