Hi all, I have a question about encoding blob bytes before inserting a record into SQLite.
CONTEXT: I have a base java (I'm using JDBC) class that has a many children. Each child may store a different data type (such as String, int, long, etc.) in its VALUE field. Since this value field could be many different data types, I will be storing the field's bytes into the database as a blob. QUESTIONS: -I have seen a couple of places on the internet saying that SQLite cannot inserting binary data unless it has been encoded. Can someone confirm this or preferrably point me to an OFFICIAL sqlite statement/page saying that this is true? -Will I need to encode my data? I do not think the String.getBytes() command returns bytes including a terminator. However, since the terminator is just 0, I assume that even storing the integer 0 as bytes in the blob would be a problem. Is it not? -It also looks like the single quote character ' (ascii decimal 39) is a problem for binary? So this also means storing integer 39 is a problem? Storing these two numbers doesn't seem like it should be a problem to sqlite, which is why I need to make sure I actually need to encode or not. Please help me out. Thanks, Julian _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
