Commented by: @mrotteveel

It would be helpful to explicitly point out the problem (eg by showing the expected vs actual result).

Commented by: Alex Bekhtin (afgm)

expected result:

===========================================================================
Некий текст на русском

Commented by: @asfernandes

Connection charset?

Commented by: @asfernandes

Are you using latest snapshot?

Commented by: @livius2

It looks like latest "Environment Firebird-4.0.0.1629-0_x64"

Commented by: @asfernandes

I cannot reproduce. Then I need completely reproducible test case, with data saved in file and isql -i command.

Commented by: Alex Bekhtin (afgm)

SET NAMES WIN1251;

CONNECT 'SOME_DB.fdb' USER 'SYSDBA' PASSWORD 'masterkey';

select substring('aaaЫЫЫccc' similar '%aaa#⁠"%#⁠"ccc%' escape '#⁠') from rdb$database;

Commented by: @asfernandes

Should be fixed now. Please test.

Commented by: Kostyukovskiy Oleg (olegvk2000)

SERVER version :WI - T6 . 3.0 . 1631 FIREBIRD 4.0 BETA 1

create domain T_A64 as varchar (64) character set WIN1251 collate WIN1251;

create table VALUT_LIST (NAME T_A64 not null);

insert into VALUT_LIST (NAME) values ('Российский рубль');
insert into VALUT_LIST (NAME) values ('Турецкая лира');
insert into VALUT_LIST (NAME) values ('Доллар США');
commit work;

SQL Query Error:

select substring(list(http://T.NAME, '; ') from 1 for 250) from VALUT_LIST T

RESULTS
CANNOT TRANSLITERATE character between character SETS.

Commented by: @asfernandes

Fixed. Please try again on next snapshot.

Commented by: @pavel-zotov

Checked on 4.0.0.1632 - all examples work fine.