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:[email protected]] På
vegne af Clemens Ladisch
Sendt: 7. august 2017 10:28
Til: [email protected]
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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
