Ann,

>> correct. But it makes a significant 0 at the end of a string
>> impossible to store.

A> Certainly it's possible to end a blob with a space. And it's also
A> legal to include trailing spaces in the counted length of a varchar.
A> Comparisons are a little funky, but ...

A> Why do you think that it would not be possible to store a
A> significant trailing zero in charset octets?

Mmm... I was sure that trailing padchars were stripped when you select
from a varchar field. As you point out, this is not the case.

And, thinking twice, I've been storing binaries in OCTETS blobs for a
long time in the past. :-)

All: sorry for the noise. An OCTETS varchar is definately ok for
binary gook.

Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================