[SOLVED] Problems with accentuation - Lazarus 226 + MySQL 8.0

[Gercino]

Hey guys,
Thank you for allowing me access to the forum.
I'm facing the following problem: When typing the word "Cão Caníl" (two accents) and exiting DBEDIT I ​​lose the formatting of the text.
But, if I insert the text directly into MYSQL I have no problem.
I've already tried changing the MySQL "collation" to "utf8" and it always returns to "uft8mb3"... I don't know if this is the problem, and for this reason I'm asking for help.

I have little experience, as you may have noticed. I'm looking to learn and exercise.

Obrigado (THKX) pela compreensão.

I'm using Win11 / Lazarus 2.6.6
MySQL8.0 (Default characterset = uft8mb3 / Default collation = utf8mb3_gerenal_ci)

[Zvoni]

Charset of the Connection?

[Gercino]

Charset of the Connection?

I'm trying like this in the event 'DataModuleCreate':
...
conexao.ClientCodePage:='utf8';
conexao.ControlsCodePage:=cCP_UTF8;
conexao.Properties.Add('codepage=UTF8');
...

[Gercino]

Charset of the Connection?

I'm trying like this in the event 'DataModuleCreate':
...
conexao.ClientCodePage:='utf8';
conexao.ControlsCodePage:=cCP_UTF8;
conexao.Properties.Add('codepage=UTF8');
...

I managed to solve the problem.

a) MySQL8.0 = CHARACTER SET = utf8mb4 and COLLATE = utf8mb4_general_ci
b) IDE =  zconnection1.ControlsCodePage:=cCP_UTF8;

OK accent, and letter 'ç'

Thks