> How do I quote a null byte? There is no way to quote a null byte in SQL.
If you're trying to pass a string with a literal null byte
in it to a perl function, it may be that underlying C code
is failing because it expects a null-terminated string; in
that case, substituting "\000" for the null byte may solve
the problem. If that doesn't work, you may have to use
hexadecimal codes.
insert into table ... values (x'61626300646566')
should always insert "abc<null-byte>def" into the table.
Regards
