Commented by: @asfernandes

FB 2.5 is right, this is the bug here.

What you want in the correct form is:

create collation win1252_unicode for win1252; -- this is special collation named (charset_unicode)
create collation ci_coll for win1252 from win1252_unicode case insensitive;

commit;
recreate table tci(id int, name varchar(30) character set win1252 collate ci_coll);
commit;
insert into tci(id, name) values(1, 'one row');
insert into tci(id, name) values(2, 'oNE rOW');
insert into tci(id, name) values(3, 'ONE ROW');
commit;
select distinct name from tci;

Commented by: @pavel-zotov

Adriano,

I never work with charset win1252 in practice, it't not actual for me.
As of win1251 charset I can get case insens. collation in it using 'create ... for utf8 from unicode' - as in 2.5

This ticket appeared due to occasional error: I've mistaked with choise of 'target' and typed 'for WIN1251' instead of 'for UTF8' - and compiler did not decline this in 3.0.

------------
OFFTOP.
Can you please translate this document:

http://asfernandes.blogspot.ru/2009/12/integracao-da-jvm-ao-firebird.html

- in English (or just write something in doc/readme.* about integrating java and Firebird) ?
I can not apply google "machine translator" because of very bad quality of such tools :-)

TIA, Pavel.

Commented by: @asfernandes

Where I said win1252, it could be win1251 as well.

About the FB/Java document, this was a work for university, it's verbose and difficult to translate.

There is more concise and in English documentation here: http://sourceforge.net/p/firebird/code/58496/tree/java-plugin/trunk/src/etc/plugin/fbjava-doc.pdf?format=raw

But note, the plugin is not working with latest core code. I'll work on this.

Commented by: @pavel-zotov

Adriano, thank you very much.