charset in Lazarus
lazarus / 21-General

----------------------------------------------------------------------
Alf Wernersson · 2021-06-28 18:19

Which charset shall I use in MariaDb or MySQl receive swedish letter
"åäöÅÄÖ" when viewing a table in Lazarus. Is it possible change
charset in Lazarus?

Regards
Alf

----------------------------------------------------------------------
Bart · 2021-06-28 18:44

Doesn't that depend on the charset used in the database?
If that is not UTF-8 you might have to "translate" to UTF-8 when
trying to display it (since Lazarus/LCL is UTF-8 based).

Bart

----------------------------------------------------------------------
Alf Wernersson · 2021-06-28 19:54

Thanks for your answer Bart!

In both a test database and test table (MariaDB) I have set charset
utf8_general_ci. In both terminal (ubuntu) and SqlYog I get "åäö" on
"Select * from tbl2". But in Lazarus program I get 3 "squares".
Any more ideas......?

----------------------------------------------------------------------
Fantablup · 2021-06-28 22:25

What db components do you use?

If Zeos, it should not be problem. But other components can be
different.

----------------------------------------------------------------------
Alf Wernersson · 2021-06-29 04:25

Hello! I am using the components which comes with Lazarus.

    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    MySQL57Connection1: TMySQL57Connection;
    SQLQuery1: TSQLQuery;
    SQLTransaction1: TSQLTransaction;     

I have not found any possibility set charsets in them.

----------------------------------------------------------------------
Fantablup · 2021-06-29 06:58

I recommend using Zeos components.
You can install them via the online package manager. Easy as a cake.
Just go to package in the menu at the top in Lazarus and there you see
it.

I would not use anything else than Zeos.

----------------------------------------------------------------------
Zvoni · 2021-06-29 07:31

Quote from: Alf Wernersson on June 29, 2021, 06:25:59 amHello! I am
using the components which comes with Lazarus.

    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    MySQL57Connection1: TMySQL57Connection;
    SQLQuery1: TSQLQuery;
    SQLTransaction1: TSQLTransaction;     

I have not found any possibility set charsets in them.  

??????????
https://www.freepascal.org/docs-
html/current/fcl/sqldb/tsqlconnection.charset.html
Considering TMySQL57Connection inherits from TSQLConnection

EDIT: It's even in the Object Inspector for the visual components