On Fri, May 11, 2012 at 10:13 PM, Joshua Shanks <jjsha...@gmail.com> wrote:
> I set the separator to tab and then in the file it is > > X'somevalue'\tX'someothervalue'\n > X'morestuff'\tX'evenmore'\n > > but with real hex values > > According to the documentation > That document you quote is describing the SQL langauge, not CSV. There is no way to enter BLOBs using CSV, that I know of. The ".import" command operatos on CSV, not SQL. > > BLOB literals are string literals containing hexadecimal data and > preceded by a single "x" or "X" character. For example: > > X'53514C697465' > > On Fri, May 11, 2012 at 6:16 PM, Simon Slavin <slav...@bigfraud.org> > wrote: > > > > On 12 May 2012, at 2:01am, Joshua Shanks <jjsha...@gmail.com> wrote: > > > >> But when I try to use the .import method the values get imported as > >> the string "X'...." instead of the hex blob value and don't get pulled > >> out correctly. > > > > .import is for .csv files. What are you putting in the .csv file to > express a value in hex ? I don't think there's a way to do it. > > > > Simon. > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
