On 19 Apr 2018, at 1:27pm, MARCHAND Loïc <[email protected]> wrote:
> CREATE TABLE Record (RecordID INTEGER,Data TEXT,PRIMARY KEY (RecordID)) > > I read a file, and for each line I add a row on the table. Each line can have > binary data at end. It's not a problem for many chars, but \0 char make a > problem. > If I have a line like this : "My data \0with binary". Although this may not be causing your problem, you should declare "Data BLOB" not "Data TEXT". Although SQLite itself doesn't care, some SQLite libraries may interpret TEXT as meaning that you want the data handled as C text, with \0 meaning a terminator. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
