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

Reply via email to