> > >Why is that? The octet strings 01hex and 0100hex are clearly two
> > >different keys.
> > INSERT INTO test VALUES (
> > cast (ASCII_CHAR(1) || ASCII_CHAR(0) as varchar(16) character set
> octets))

I think your cast to varchar will mean that the string will be truncated to
2 char
try casting to CHAR(16)
Alan