Nathan Kurz <[EMAIL PROTECTED]> wrote: > > > So as far as I can tell, both SQLite and Perl are doing exactly what > > they ought to be. > > That certainly could be argued, although it does seem to trap the > unwary (like me) with fair regularity. One option for 'improving' it > might be to make 'BLOB' become a bona fide column affinity, so that a > TEXT type inserted into a BLOB column would be stored as a blob. > > Would there be a downside to do this? >
You mean besides breaking backwards compatibility? ;-) For one, it is not clear to me what to do when you insert an integer into a BLOB column. Do I convert the integer to text first then store the text as a blob. Or do I store the twos complement representation of the integer as a blob. And how many bytes of the integer - internally SQLite has 1, 2, 3, 4, 6, and 8 byte integers. All of this gets very merky, so I figure the best approach is to do nothing. -- D. Richard Hipp <[EMAIL PROTECTED]>
