Hello,
 
I like Firebird database more than 10 years:-)
 
I always use for VARCHAR value character set WIN1250 and COLLATION PXW_CSY...
Now I need to you UTF8 and I need to have correct CZECH collation...
 
I have found some information, I must use ICU and add collation to Firebird...
 
In march 2013 I have success I was doing:
1) download Firebird 2.5.2.26539 for windows x64, install it on Windows 7 64bit
2) download ICU 4.8.1.1. (from http://site.icu-project.org/download <http://www.google.com/url?q=http%3A%2F%2Fsite.icu-project.org%2Fdownload&sa=D&sntz=1&usg=AFQjCNH1JtxAMs3yLN5YxuiZ1ZLMHQkNQg> exactly icu4c-4_8_1_1-Win64-msvc10.zip)
3) copy files form ICU icudt48.dll, icuin48.dll and icuuc48.dll to ..\Firebird\bin\
4) edit file fbintl.conf in ..\Firebird\intl\  , change section intl_module builtin to this (only added 4.8 after default):
<intl_module builtin>
    icu_versions    default 4.8
</intl_module>
5) restart firebird server
6) create new collation
create collation UNICODE_CSCZ_CI
   for UTF8
   from UNICODE
   case insensitive
   'LOCALE=cs_CZ;ICU-VERSION=4.8';
Then I can use Czech national sorting :-) it was great... I was happy...
 
But today... I have problem...
Now I tried use these steps for Firebird 2.5.3.26778 and there is something wrong :(
When I tried:
create collation UNICODE_CSCZ_CI
   for UTF8
   from UNICODE
   case insensitive
   'LOCALE=cs_CZ;ICU-VERSION=4.8';
I get error message:
This operation is not defined for system tables.
unsuccessful metadata update.
Invalid collation attributes.
 
So I was tried my old "steps" and Firebird 2.5.2 and ICU 4.8.1.1... and it was wrong too... :(
I used all combination Firebird 2.5.2 and 2.5.3. with ICU 4.8.1.1. and ICU 54.1 on win7 32bit, win7 64bit, win xp 32bit... and in fbintl.conf i tried too only
<intl_module builtin>
    icu_versions    4.8
</intl_module>
 
Can you help me? What is wrong? It seems that firebird server doesnt use added ICU library...
 
Thank you
 
ZSE






[Non-text portions of this message have been removed]