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
from the self compiled Firebird version to /usr/lib64 and to change
<intl_module builtin>
icu_versions default
<intl_module builtin>
icu_versions default 3.0
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. ;-)