--- In firebird-support@yahoogroups.com, "Vlad Khorsun" <hvlad@...> wrote:
> > CREATE TABLE test
> > (
> > Id VARCHAR(16) CHARACTER SET OCTETS NOT NULL,
> > PRIMARY KEY (Id)
> > );
> >
> > COMMIT;
> >
> > INSERT INTO test VALUES (ASCII_CHAR(1));
> > INSERT INTO test VALUES (ASCII_CHAR(1) || ASCII_CHAR(0));

> Per SQL standard trailing blanks are not accounted at strings
comparison. I.e. 'a' == 'a '.
> Character set OCTETS have defined 0x00 as blank character, so {0x01}
== {0x01, 0x00}

Thanks. That clears things up. Is there a character set where 0x00 is
not a blank character?

Cheers,
Christof