Maybe this question was already asked and explained.
Or maybe it is documented somewhere (could not fiund it).
Sorry, if this is the case, but why does

SELECT '' = x'';

yields 0?

Suppose I have data in FOO table. By what means can I tell 
what is inside of my_blob column of FOO, when

SELECT length(my_blob) FROM FOO;

returns 0 for both empty string('') and empty blob (x'') alike? 
And what is the reason behind this difference?

Thanks,
Paul

Reply via email to