Feature Request for sqlite3conn.AddFieldDefs

Summary

The current Sqlite3Connection-Implementation doesn't support FTS-Tables correctly.

See also thread in Forum: https://forum.lazarus.freepascal.org/index.php/topic,66335.0.html

Specifically pawel's Posts #5 and #8

My Posts #16 and #18 are the results of small tests

Current implementation assigns ftString to Query-Results on FTS-Tables, which cuts resulting fields off at 1020 characters

Adding a line

• if FT=ftUnknown then
•       case TStorageType(sqlite3_column_type(st,i)) of
•         stInteger: FT:=ftLargeInt;
•         stFloat:   FT:=ftFloat;
•         stBlob:    FT:=ftBlob;
•         stText:    FT:=ftMemo;  //THIS ONE WAS ADDED
•         else       FT:=ftString;
•       end;                

returns correct results.

Though: No idea if it would break anything else.

Sorry for not providing a patch. Don't have "trunk"-source nor Diff-Tool available. And sorry, if i'm here in the wrong section