I suspect, from experimentation, that substr() is not binary safe,
in that if some part of the field contains an all-bits-zero byte,
it will "stop short".
What I wish to do is to pick out byte ranges of arbitrary length,
at an arbitary offset into a BINARY(N) column.
Perhaps LEFT() and RIGHT() might be my friends? I haven't been
able to set up sufficient experiments yet.
Can anyone confirm, or make further suggestions?
Michael Fischer Happiness is a config option.
michael@stripped Recompile and be happy.
|• SUBSTR(...) on BINARY column?||Michael Fischer||8 Nov|