From: Jeremy Hinegardner <jeremy@...>
Date: 2008-07-06T15:22:11+09:00
Subject: Re: sqlite3 Re: title avoiding spurious response

On Sun, Jul 06, 2008 at 02:56:43PM +0900, Une B?vue wrote:
> 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" ???

Possibly, but I wouldn't be for sure.  In the other thread it looks like you
have worked around it, so I guess that will work for you.

enjoy,

-jeremy

-- 
========================================================================
 Jeremy Hinegardner                              jeremy@hinegardner.org