Adriano, thank You for Yor reply. !Besos!

(From readme.intl.txt)
create collation win1252_unicode for win1252;
WORKS

(from tracker core-635)
CREATE COLLATION UNICODE_CZ FOR UTF8 FROM UNICODE 'LOCALE=cs_CZ';
FAILS:Invalid collation attributes

(tracker core-824 (?))
CREATE COLLATION UNICODE_CI2 FOR UTF8 FROM UNICODE_CI;
WORKS (but quite pointless, right?)

and of course:
ALTER TABLE SWTEST ADD
test2 Char(25) CHARACTER SET UTF8 COLLATE UNICODE_CI;
WORKS

select * from swtest order by test2 collate cs_CZ;
FAILS: Data type unknown
COLLATION CS_CZ for CHARACTER SET UTF8 is not defined
(did try EN_US, EN_GB as well - no luck)

And UNICODE_CI does still order A, å, B, O, &oring, Z...

-----

One solution however, would be if fbclient can remap charset
<client utf8> <fbclient> <db win1252> but that can't be done, right?

As always, thankful for any help!

27 okt 2008 kl. 18.32 skrev Adriano dos Santos Fernandes:

> tjelvare escreveu:
> > In firebird tracker this post,
> > http://tracker.firebirdsql.org/browse/CORE-635
> > seems to point out that it's all ok,
> > (except that I'd like the collation to be ci as well)
> >
> Looks for UNICODE_CI / UNICODE_CI_AI on v2.1 / v2.5 release notes, or
> search the tracker - I didn't remember in what version each was added,
> and try the command substituting UNICODE by the collation you want.
>
> Anyway, I'm not sure if custom locales are still activated by our
> version of ICU. If they are, it's only the Czech and maybe another
> one.
>
> Adriano
>
>
>

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