Jeremy Hinegardner <jeremy / hinegardner.org> wrote:

> try this from the sqlite3 command line and see what you get:
> 
>   select id, typeof( title ), typeof( guid ) from moz_bookmarks;
> 
> That will tell you the internal sqlite storage type of the field you are
> requesting.  I'm assuming the problem is with one of those fields, so try
> typeof() on any field that you want to test out.

id   INTEGER PRIMARY KEY -> integer
type             INTEGER -> integer
fk               INTEGER -> integer | null
parent           INTEGER -> integer
position         INTEGER -> integer
title        LONGVARCHAR -> text | null
keyword_id       INTEGER -> integer | null
folder_type         TEXT -> text | null
dateAdded        INTEGER -> integer
lastModified     INTEGER -> integer


I would suspect "LONGVARCHAR" ???
-- 
Une B?vue