Hi all,

Is this error expected?

# isql -ch utf-8
create database '/var/tmp/teste-utf8.fdb';
commit;

connect '/var/tmp/teste-utf8.fdb';

recreate table test (
column1 varchar(10) character set none collate none );

insert into test values ('1234567890');
commit;

select coalesce(column1, null) from test;

COALESCE
==========
1234567890

select coalesce(column1, '') from test;

COALESCE
========
Statement failed, SQLCODE = -802
arithmetic exception, numeric overflow, or string truncation

Regards,

Fabiano