Why is SQLite pinching off text field at 255 characters

[bobonwhidbey]

I use these units sqldb, sqlite3conn.

The DB table has been created with
 Query.SQL.Text := 'CREATE TABLE Data (ID int, Key text,Value text, PRIMARY KEY (ID,Key));';

I can view the DB file with DBBrowser for SQLite (a great program BTW) and see that the fields in question are about 1,500 characters long.The following reads the correct fields from the table BUT truncates the data.

 Query.SQL.Text := 'SELECT * FROM Data Where Key="ScoreTable"';
 s :=Query.FieldByName('Value').AsString; // only 255 characters in s ??

I can provide sample program and DB file that illustrate the problem.  TIA for your help

[GAN]

Key is a reserved word in SQLite, not's a good idea to use it as a field's name.
Your var s must be ANSI String:

The type String may refer to ShortString or AnsiString, depending from the {$H} switch. If the switch is off ({$H-}) then any string declaration will define a ShortString. It size will be 255 chars, if not otherwise specified. If it is on ({$H+}) string without length specifier will define an AnsiString, otherwise a ShortString with specified length. In mode delphiunicode' String is UnicodeString.

From wiki http://wiki.freepascal.org/Character_and_string_types

[bobonwhidbey]

ansistring didn't work for me 

I've attached the simple program and data file that shows the issue. Only 87 KB

[bobonwhidbey]

Because of size restrictions, you will have to add the sqlite3.dll to your folder.

This attachment has all other necessary files