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 <[email protected]> wrote:
>
> On 12 May 2012, at 2:01am, Joshua Shanks <[email protected]> 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
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
