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
--
Michael Fischer Happiness is a config option.
michael@stripped Recompile and be happy.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.