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