collation is not installed

[Hamish Moffatt]

I have Firebird 2.5.9 installed on Debian Linux (from old Debian
packages); when trying to use any collation I get an error saying it's
not installed:


$ isql-fb mydb
Database:  mydb
SQL>  select class_name from g_class order by class_name collate unicode;
Statement failed, SQLSTATE = 22021
COLLATION UNICODE for CHARACTER SET UTF8 is not installed

This is working on 2.5.9 on Windows though, on the same database (from
the firebirdsql.org downloaded binaries).

What am I missing to make it work on my linux installation?


thanks

Hamish

[Сергей Волков]

You have a different version of iсu library in Windows (3.0) and Debian (5.2). Install Firebird on debian from the official site, not from debian repository, or make a backup on windows and restore on debian.

ср, 7 сент. 2022 г. в 12:19, 'Hamish Moffatt' via firebird-support <firebird...@googlegroups.com>:

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/1a78aba8-3019-c97a-91fc-e6c11fee188d%40risingsoftware.com.

[Hamish Moffatt]

OK, it is just some database files, not the server, and if I gbak
backup/restore them then the collation works afterwards on the new copy.

Can I install the collation somehow without backup/restore?


SQL> create collation UNICODE_CI for UTF8;
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-Collation UNICODE_CI not installed for character set UTF8

From RDB$COLLATION it appears the collation is known, just 'not installed':


SQL> select * from rdb$collations where rdb$collation_name='UNICODE_CI';

RDB$COLLATION_NAME RDB$COLLATION_ID RDB$CHARACTER_SET_ID
RDB$COLLATION_ATTRIBUTES RDB$SYSTEM_FLAG   RDB$DESCRIPTION
RDB$FUNCTION_NAME RDB$BASE_COLLATION_NAME RDB$SPECIFIC_ATTRIBUTES
===============================================================================
================ ==================== ========================
=============== =================
===============================================================================
===============================================================================
=======================
UNICODE_CI 3                    4                        3 1           
<null> <null> UNICODE 1d:12c
==============================================================================
RDB$SPECIFIC_ATTRIBUTES:
COLL-VERSION=153.88
==============================================================================


Although after restore this has changed to a different coll-version:


SQL> select * from rdb$collations where rdb$collation_name='UNICODE_CI';

RDB$COLLATION_NAME RDB$COLLATION_ID RDB$CHARACTER_SET_ID
RDB$COLLATION_ATTRIBUTES RDB$SYSTEM_FLAG   RDB$DESCRIPTION
RDB$FUNCTION_NAME RDB$BASE_COLLATION_NAME RDB$SPECIFIC_ATTRIBUTES
===============================================================================
================ ==================== ========================
=============== =================
===============================================================================
===============================================================================
=======================
UNICODE_CI 3                    4                        3 1           
<null> <null> UNICODE 1d:1fa
==============================================================================
RDB$SPECIFIC_ATTRIBUTES:
COLL-VERSION=153.14
==============================================================================



Though as an experiment I copied both the FDB files over to Mac and
Windows with Firebird 2.5.9 and all complained about the collation not
being installed.


Hamish

[Dimitry Sibiryakov]

'Hamish Moffatt' via firebird-support wrote 08.09.2022 1:48:
> OK, it is just some database files, not the server, and if I gbak backup/restore
> them then the collation works afterwards on the new copy.
>
> Can I install the collation somehow without backup/restore?

I cannot remember if version 2.5 of gfix has switch -icu but it is exactly
supposed to adapt database to local ICU version.

--
WBR, SD.

[Hamish Moffatt]

It does not. So, backup/restore is the only way?


Thanks

Hamish