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
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
