Subject Re: How to know the ICU version of a collation in a database
Author Martin Schreiber
On 08/03/2016 05:21 PM, Martin Schreiber wrote:
> Hi,
> Since an online update on my OpenSUSE Leap 42.1 I get the well known
> error "COLLATION UNICODE_CI for CHARACTER SET UTF8 is not installed".
> I assume that something changed with the ICU libraries.
> How can one find out the used ICU library version of a database?
>
For the record:
I assume that I actually did not run the OpenSUSE installed firebird
version before but a version I compiled myself with ICU 3.0 default and
that OpenSUSE restored the original startscript. I could fix the issue
by copying the ICU 3.0 library files
libicudata.so.30
libicudata.so.30.0
libicui18n.so.30
libicui18n.so.30.0
libicuuc.so.30
libicuuc.so.30.0
from the self compiled Firebird version to /usr/lib64 and to change
/usr/lib64/firebird/intl/fbintl.conf
"
<intl_module builtin>
icu_versions default
</intl_module>
"
to
"
<intl_module builtin>
icu_versions default 3.0
</intl_module>
"
I am still interested how one can find out the used ICU version (or
versions?) of a database file.

BTW, I am the author of the very sophisticated and very unknown cross
platform development environment MSEide+MSEgui for Free Pascal which has
excellent Firebird support - I think. ;-)
https://sourceforge.net/projects/mseide-msegui/

Martin