Topic: blob binary-> varchar binary
create procedure test returns ( res varchar (100); b blob sub_type binary; s varchar (100) character set binary) as begin s = x ' 013000AA13FF '; b = x ' 013000AA13FF '; if (b=s) then begin res = 1; suspend; end s = b; if (b=s) then begin res = 2; suspend; end b = s; if (b=s) then begin res = 3; suspend; end s = b; if (b=s) then begin res = 4; suspend; end end
I receive values res=1,3,4. At assignment to a binary line of value binary (s=b) "unreadable" characters are replaced with a point. Why after all a line too the binary! How correctly to thrust value from binary in a binary line?