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