Subject character count with CHAR type on UNICODE charset
Author Leos Urban
Hello,
I have one simple question - when I insert value to CHAR(1) field on
UNICODE_FSS database, SELECT returns 3 characters.
I use Firebird SS 1.0.796 on Windows XP platform (the same efects was on
Linux too).

Example:
create database "localhost:/database/wis.gdb" page_size 4096 default
character set UNICODE_FSS;
connect localhost:/database/wis.gdb;
CREATE DOMAIN IDKONTAKT AS integer;
CREATE DOMAIN PRIVATNI AS char(1);
create table kontakty
(
kontakt IDKONTAKT not null,
privatni PRIVATNI not null,
constraint kontakty_pk unique(kontakt)
);
commit;
insert into kontakty values (1,'N');
commit;
select '->' || privatni || '<-' from kontakty;
/* returns ->N <- (N and 2 spaces) */

When I use Varchar instead Char, it works as I expected and returns 'N'.
Is this bug or feature?

The same output is in JayBird (3 chars), but (if I remember) the Interclient
returned one Unicode character ?

Leos