Subject ERROR: COLLATION UNICODE_CI_AI for CHARACTER SET UTF8 is not installed
Author orologic_inc
Hi,

I have a customer that is trying to restore one of my databases on his Debian box. My database was created on Windows and I sent him a backup file (created using gbak) of my database.

When he tries to retore it using gbak, he is getting the following error message:
ERROR: COLLATION UNICODE_CI_AI for CHARACTER SET UTF8 is not installed

So, after some research, I found that ICU libraries version seams to be the problem. On my Windows box, the ICU file version I have is version 3.0. On the Debian box, the version seams to be 4.4 or 44.

I thought that doing a backup from my Windows box then restore it on the Debian box should fix the ICU libraries incompatibility problem but it looks that it does not help. We both are also using Firebird 2.5.

So, what is the correct way to get arround that problem?

Should I upgrate my ICU dll's on my Windows box to version 4.4? Is it possible to do that anyway?

Or is there a way my customer downgrade to version 3.0?

Thanks in advance.

Guylain Plante