Patrik Nilsson wrote:
After dumping the database I found that the line of insertion looks like
this
INSERT INTO "repetition"
VALUES(617,X'323031322D31322D32332031393A33303A3436',X'30',X'323031322D31322D32332031393A33303A3436',0,1,1,0);
Does SQLite manage the insertion with hexadecimal characters?
Those hex digits are part of what the SQLite docs call a blob literal.
The 3rd column is greater than zero and is the ASCII code for the
character we call zero. I expect that your code for displaying results
is disguising that fact. I also expect that you will want to find
where/why blobs are being inserted, and get the inserted types to be
closer to what is supposed to be represented. (number, string, etc.)
The BLOB is really for raw data that is not to be further interpreted as
anything else.
Cheers,
--
Larry Brasfield
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
