RE: [firebird-support] Re: Collation with Numeric-Sort and index

[Magnus Johansson mag...@nimajo.se [firebird-support]]

From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com]
Sent: Friday, September 22, 2017 9:06 AM

Did you have a setup (version of FB and ICU) that passes these tests?

No, I have not been able to find a config that works.
Tested again for both FB 3.0 and FB 4.0 using the latest snapshots as of today 
against the full version of ICU 52, results are the same.
Firebird-3.0.3.32805-0_x64.
Firebird-4.0.0.749-0_x64.
icu4c-52_1-Win64-msvc10.

I do not use CI so i have not suffered from the potential disasters you point 
put above.
IMHO looks like bugs.

I have posted in FB-Devel about this, although the last response was a while 
ago now.

Regards,
Magnus Johansson

RE: [firebird-support] Re: FB 3.0 Replacing ICU libraries

[Magnus Johansson mag...@nimajo.se [firebird-support]]

Hi Dany,

Do you mind sharing which character set you use and how your collation is 
defined?

Mvh
Magnus Johansson

RE: [firebird-support] FB 3.0 Replacing ICU libraries

[Magnus Johansson mag...@nimajo.se [firebird-support]]

Mark, I wholeheartedly agree with you.



I too tried it with 2.5 but didn't success so I gave up at that time.

>From what I have been able to read, the documentation that exists seems to be 
>a mix on both 3.0, 2.x and even 1.5 making it a little unclear.

Especially as README.intl.txt also mentions "you can replace ICU libraries by a 
complete one found in our site", but I don't remember ever having found 
anything like that on firebirdsql.org.



Thanks for your input,

Magnus


From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Tuesday, September 12, 2017 10:34 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] FB 3.0 Replacing ICU libraries



On 2017-09-12 10:15, Magnus Johansson mag...@nimajo.se
[firebird-support] wrote:
> Hi All,
>
> Perhaps my previous post about collation problem was too long so that
> nobody cared to read it through, so let me start with a simpler
> question.
>
> I need unicode collation for Swedish and therefore I have to replace
> the ICU libraries.
>
> First I have downloaded the snapshot for FB 3.0.3 for Windows
> (Firebird-3.0.3.32802-0_x64).
>
> Then I went to http://site.icu-project.org/download and downloaded
> icu4c-52_1-Win64-msvc10.zip from where I got the icu*52.dll's and
> extracted them to the FB3 folder, replacing the existing ones.
>
> No changes done in intl\fbintl.conf or anything else.
>
> I would appreciate if anyone could just answer if this is the correct
> way to do this.

I believe this is the correct approach, but I have only tried it once
with Firebird 2.5 and ran into some compatibility issues at that time.
Unfortunately this is - afaik - entirely undocumented.

Personally I'd prefer if Firebird was just released with the full ICU
library instead of the trimmed down version.

Mark

[firebird-support] Re: FB 3.0 Replacing ICU libraries

[Magnus Johansson mag...@nimajo.se [firebird-support]]

From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] 
Sent: Tuesday, September 12, 2017 10:32 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: FB 3.0 Replacing ICU libraries

> I would appreciate if anyone could just answer if this is the correct way to 
> do this.

Seems, yes, but better ask in fb-devel and i hope Adriano will explain things

Regards,
Vlad

Thanks for answering Vlad, will do that.
See you in Prague. :-)

Regards,
Magnus Johansson

[firebird-support] FB 3.0 Replacing ICU libraries

[Magnus Johansson mag...@nimajo.se [firebird-support]]

Hi All,

Perhaps my previous post about collation problem was too long so that nobody 
cared to read it through, so let me start with a simpler question.

I need unicode collation for Swedish and therefore I have to replace the ICU 
libraries.

First I have downloaded the snapshot for FB 3.0.3 for Windows 
(Firebird-3.0.3.32802-0_x64).
Then I went to http://site.icu-project.org/download and downloaded 
icu4c-52_1-Win64-msvc10.zip from where I got the icu*52.dll's and extracted 
them to the FB3 folder, replacing the existing ones.
No changes done in intl\fbintl.conf or anything else.

I would appreciate if anyone could just answer if this is the correct way to do 
this.

Regards,
Magnus Johansson