Submitted by: Minoru Yoshida (timeful2)

Attachments:
test.sql
TEST.fbk
test.sql

On V2.0.5 with UTF8 client connection,
Lost the supplementary characters(UTF-8 4byte) at immediate API handling.
e.g. U+20BB7 is UTF-8 4byte character(0xF0A0AEB7)
http://www.unicode.org/cgi-bin/GetUnihanData.pl?codepoint=20bb7

Not immediate API(Using parameter) handling is working fine.
e.g. In Delphi,
...
Query1.SQL.text := 'Insert into TEST(K, N) Values(5,:P1)';
Query1.ParambyName('P1').Asstring := '��';/* 4-Byte UTF-8 0xF0A0AEB7 */
Query1.Execute;
...

The NONE client connection that handling is worked,
and V2.1.2RC all works fine.

Reproduce:
//Please see attachment file.
1. Copy TEST.fdb database to c:\temp folder.
2. Run isql.exe
3. > input test.sql;
4. Open out.txt

Lost the 4-Byte UTF-8 characters...

       K N      

============ ======
1 A
2 ±
3 あ
4
5

-- test.sql(UTF-8 format text)

Set Names UTF8;
Set SQL Dialect 3;
Connect 'c:\temp\TEST.fdb' user 'sysdba' password 'masterkey';

Shell del out.txt;
Output out.txt;

/*Create table*/
Drop table TEST;
Create Table TEST(K INTEGER Not Null, N VARCHAR(1)
, Constraint PK Primary Key (K));

Insert into TEST(K, N) Values(1,'A'); /* 1-Byte UTF-8 0x41 */
Insert into TEST(K, N) Values(2,'±'); /* 2-Byte UTF-8 0xC2B1 */
Insert into TEST(K, N) Values(3,'あ'); /* 3-Byte UTF-8 0xE38182 */
Insert Into TEST(K, N) Values(4,'��'); /* 4-Byte UTF-8 0xF0A0AEB7 */
Insert into TEST(K, N) Values(5,'��'); /* 4-Byte UTF-8 0xF0A0AE9F */
Commit;

Select * from TEST; /* Select all */
Select * from TEST Where N = '%��%'; /* Select 4-Byte UTF-8*/
Commit;

Commits: 3024e8a