users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of si666 [si.for...@gmail.com]
Sent: Thursday, November 17, 2011 8:26 AM
To: sqlite-users@sqlite.org
Subject: EXT :Re: [sqlite] Export Blob data from sqlite database to html
Thanks for the reply Pris;
I have already tried a
On 17 Nov 2011, at 2:26pm, si666 wrote:
> I was wondering if there's a sql query i could run on the whole database
> which would look at the value in the type field and then handle the data
> field as either ascii or an image?
There is no way to handle an image in SQL. The language handles only
Thanks for the reply Pris;
I have already tried a number of sqlite browsers without success. Using them
I can export the tables but when I open the resulting html or csv they
interpret the hex of the time stamps and jpegs as ascii which chucks out
jiberish.
I was wondering if there's a sql quer
I'd agree with the SQLite Expert option (Windows)...it ships, or at least
used to ship with sample data that presents a scenario like you're
describing (ie, jpeg and text as BLOB), plus it allows visual assists, such
as BLOB masking over a certain size of data in a column. Otherwise, you'd
need to
At 10:02 16/11/2011, you wrote:
Basically my problem is exporting the database so the time stamps
appear in
hex the data blobs appear in either text (ascii) or as a jpeg image
depending on the data in type field.
I have tried numerous sqlite browsers without success.
Looks like a job for SQL
Maybe you can use a tool like sqlitebrowser to open up the database, then
export tables you want to csv?
Pris
On Thu, Nov 17, 2011 at 3:10 AM, si666 wrote:
>
> I already have, they told me to go away...
>
>
> luuk34 wrote:
> >
> > On 16-11-2011 10:02, si666 wrote:
> >> I have a sqlite database
I already have, they told me to go away...
luuk34 wrote:
>
> On 16-11-2011 10:02, si666 wrote:
>> I have a sqlite database from a iphone chat app which I would like to
>> present
>> in a human readable format either csv, html or other.
>
> you should ask the author of that iphone app ;)
>
On 16-11-2011 10:02, si666 wrote:
> I have a sqlite database from a iphone chat app which I would like to present
> in a human readable format either csv, html or other.
you should ask the author of that iphone app ;)
___
sqlite-users mailing list
I have a sqlite database from a iphone chat app which I would like to present
in a human readable format either csv, html or other.
The database has over 600 tables with multiple rows of conversation, the
fields are:
sender (text) - servertime (blob) – localtime (blob) – type (text) –
data(blob)
9 matches
Mail list logo