Since I have blobs, datetimes, and integers I managed to use the hex-convertion on some integers as well. They are stored as text in my program.
I changed the code for the interval integer, so it is inserted as an integer. It seems to work. I don't get this strange kind of selection anymore. Thank you for the dump command. /Patrik On 12/23/2012 09:52 PM, Larry Brasfield wrote: > 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, _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
