Submitted by: @asfernandes

Is related to QA208

Votes: 1

Thomas Steinmaurer wrote in fb-devel:

set names utf8;

create database 'C:\firebird_utf8_test\utf8_test.fdb' user 'sysdba'
password 'masterkey' page_size 4096;

create table t1 (
t1_id integer not null
, vc_50_utf8_utf8 varchar(50) character set utf8 collate utf8
, vc_50_utf8_unicode varchar(50) character set utf8 collate unicode
, constraint pk_t1_id primary key (t1_id)
);

commit;

create index i_vc_50_utf8_utf8 on t1 (vc_50_utf8_utf8);

commit; -- Works

create index i_vc_50_utf8_unicode on t1 (vc_50_utf8_unicode);

commit; -- <= Error message here

Commits: 06cf57b 53ac9b7

====== Test Details ======

Note: limitations in recent FB versions are much greater than values specified in test.