> -----Original Message-----
> From: Adriano dos Santos Fernandes [mailto:[email protected]]
> Sent: Tuesday, September 12, 2017 2:34 PM
> To: [email protected]
> Subject: Re: [Firebird-devel] FB 3.0 Replacing ICU libraries on Windows
>
> > CREATE COLLATION ISO_SV_CI
> > FOR ISO8859_1
> > FROM SV_SV
> > CASE INSENSITIVE;
>
> This is old collation inherited from Interbase or
> earlier developed in Firebird before ICU adoption. It probably is not
> suitable for
> CASE INSENSITIVE or others options.
Good info, great to know.
Then I guess I can omit that as an option and concentrate on charset UTF8.
> If you want to use ICU with ISO8859_1, you should use ISO8859_1_UNICODE in
> FROM.
Not that it probably matters for me anymore based on what you wrote above, but
for the record I tried that with both the original ICU and ICU for 52.1, both
gives:
"COLLATION ISO8859_1_UNICODE for CHARACTER SET ISO8859_1 is not defined"
Although I can see that it exists in fbintl.conf:
charset = ISO8859_1 {
intl_module = fbintl
collation = ISO8859_1
collation = ISO8859_1_UNICODE
...
}
> > SELECT FIELD_UTF_SV_CI_NUM
> > FROM TABLE_T
> > WHERE FIELD_UTF_SV_CI_NUM BETWEEN '' AND 'b'
> > ORDER BY 1;
> >
> > FIELD_UTF_SV_CI_NUM
> > ===================
> > 1
> > 2
> > 10
> > 20
> > a
> > A
> > aa
> > Aa
> > AA
> > b
> > ===================
> > Not the expected result.
> > Where did the 'B' go?
>
> This should be verified.
Is there anything I can do here?
After looking a little more on this it seems that it is the last record that is
missing.
> You can also test:
>
> CREATE COLLATION UTF_SV_CI_NUM
> FOR UTF8
> FROM UNICODE
> CASE INSENSITIVE
> 'LOCALE=sv_SE;NUMERIC-SORT=1;MULTI-LEVEL=0';
I read about MULTI-LEVEL in README.intl.txt and must confess that I'm not sure
of what that means.
However, I can't see any difference with my tests using it in either way.
Adriano, thanks for your time on this.
And judging by your comments I take it that the steps I had taken and described
in how to replace the ICU libraries was correct and sufficient?
Regards,
Magnus Johansson
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
