Thank you Clemens! I am trying to learn FireDAC and SQLite, indeed a steep learning curve! I just realized that it is possible to replace TEXT with VARCHAR(). I have followed 2 tutorials about SQLite, and none of these mentioned the VARCHAR() possibility.... But I also realized that it is not possible just to put some greek (unicode) characters into a field. It ends up with a mix of latin chars and questionmarks. Is there a (simple) solution on this problem?
Regards Lars -----Oprindelig meddelelse----- Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Clemens Ladisch Sendt: 7. august 2017 08:33 Til: sqlite-users@mailinglists.sqlite.org Emne: Re: [sqlite] TEXT shows as (WIDEMEMO) in DBGrid Lars Frederiksen wrote: > CREATE TABLE gms( > gms_id INTEGER PRIMARY KEY, > gms_verb TEXT NOT NULL > ); > > FDTable1.Append; > FDTable1.FieldByName('gms_verb').AsString:= Edit1.Text; FDTable1.Post; > > But when I put a string in the table 'gms_verb' I only get the primary > key number - the string is shown like (WIDEMEMO). In SQLite, all text values are Unicode and can have an arbitrary size, so dtWideMemo is what FireDAC thinks is the best match. You could use a different type name, or set up a type mapping: http://docwiki.embarcadero.com/RADStudio/XE7/en/Using_SQLite_with_FireDAC#SQLite_Data_Types Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
