[Lazarus] Help reading SQLite field with more than 255 chars

[Marcos Douglas]

On Mon, Nov 18, 2013 at 7:00 PM, mulcamd <mulcamd at hotmail.com> wrote:
> I’m reading the SQLite database of Adobe Lightroom (SQLite).
>
>
>
> I want to process the AdditionalMetadata table, see below, the XMP field,
> which may be 3000 chars long.
>
> When retrieving the contents of this field I only get 255.
>
>  [...]
>
>
>
> CREATE TABLE Adobe_AdditionalMetadata (
>
>   [...]
>
>    monochrome INTEGER NOT NULL DEFAULT 0,
>
>     xmp NOT NULL DEFAULT ''
>
> )

The "xmp" column should be TEXT type.

--
Marcos Douglas