1

Topic: blob binary-> varchar binary

FB 2.5.5

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?

2

Re: blob binary-> varchar binary

varchar binary wrote:

Why after all a line too the binary!

?

3

Re: blob binary-> varchar binary

wadman wrote:

it is passed...
?

Oh... smile))

4

Re: blob binary-> varchar binary

Checked up in triple - shows res=1,2,3,4. Delivered 2.5.7 - res=1,3,4. A bug?

5

Re: blob binary-> varchar binary

varchar binary;
I also did not know that such coding exists. Normally for the binary data coding OCTETS is used

6

Re: blob binary-> varchar binary

Simonov Denis, binary = octets. With octets the same result.