It would be so much easier if you could provide hex dumps of the strings involved. Maybe just a few characters and a verbal description of what you think you are storing (greek lowercase alpha, ...).
From appearances it seems that your text objects are locale aware, which would suggest a code-page based approach instead of UTF8. Hint: If what you put in is all special characters and half as long as what is returned, then you are converting ISO to UTF8 somewhere along the way. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Lars Frederiksen Gesendet: Montag, 07. August 2017 10:39 An: 'SQLite mailing list' <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] TEXT shows as (WIDEMEMO) in DBGrid Hi, My code is simple. FDConnection, FDQuery, DataSource + DBGrid, 3 Edits and a button. Then this OnClick event: Procedure TForm1.Button1Click(Sender: TObject); begin FDTable1.Open; FDTable1.Append; FDTable1.FieldByName('gms_id').AsInteger:= StrToInt(edNummer.Text); FDTable1.FieldByName('gms_graesk').AsString:= edGræsk.Text; // this is greek letters but in DBGrid it is something like '?e? e??ae ?a???' FDTable1.FieldByName('gms_dansk').AsString:= edDansk.Text; FDTable1.Post; end; Regards Lars -----Oprindelig meddelelse----- Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Clemens Ladisch Sendt: 7. august 2017 10:28 Til: sqlite-users@mailinglists.sqlite.org Emne: Re: [sqlite] TEXT shows as (WIDEMEMO) in DBGrid Lars Frederiksen wrote: > I have followed 2 tutorials about SQLite, and none of these mentioned the > VARCHAR() possibility.... Because SQLite pretty much ignores column types. Interpreting "VARCHAR" this way is how FireDAC does things; you have to look into the FireDAC documentation. > 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? Yes: fix the bugs in your code (which you have not shown). 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 ___________________________________________ Gunter Hick Software Engineer Scientific Games International GmbH FN 157284 a, HG Wien Klitschgasse 2-4, A-1130 Vienna, Austria Tel: +43 1 80100 0 E-Mail: h...@scigames.at This communication (including any attachments) is intended for the use of the intended recipient(s) only and may contain information that is confidential, privileged or legally protected. Any unauthorized use or dissemination of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail message and delete all copies of the original communication. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
