I think that this string "0 but true" is a very ancient artifact dating from before scientific notation. I have never seen this in my coding. I have however encountered "0E0" with the DBI as the normal, standard way to say "statement worked correctly, but produced a zero result", true in a logical comparison sense, but numeric zero in a numeric sense.