From: unbewusst.sein@... (=?ISO-8859-1?Q?Une_B=E9v?= =?ISO-8859-1?Q?ue?=)
Date: 2008-07-06T14:56:43+09:00
Subject: Re: sqlite3 Re: title avoiding spurious response

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