Subject AW: [firebird-support] Data type for small binary data
Author Steffen Heil
Hi

> VARCHAR(...) CHARACTER SET OCTETS

Nice.

Yet I remembered that varchars would loose leading and trailing spaces? That
would mean that any (byte)32 could get lost, doesn't it?
(My current test seems to imply that this memory was false, but I need to be
absolutely sure.)

Can I be sure that there will never by any transliteration problem
whatsoever?
I always do have a feeling that varchar and char columns may be treaded as
characters and that could be a source of lots of problems.
Mostly my data is absolutely random and I cannot accept to loose any byte.

(For firebird-java: All the above question only apply ti getBytes(), I will
surely never call getString() on any such field.)

Regards,
Steffen




------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links




[Non-text portions of this message have been removed]