charset in Lazarus

[Alf Wernersson]

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]

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]

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]

What db components do you use?

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

[Alf Wernersson]

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]

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]

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.   

??????????
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