xsharp.eu

Hi, any of you use MariaDB and have updated to version 10.6?
I did, and there are problems with the Net connector Mysql.Data.DLL .
I solved it, but I wanted to check with others for an opinion on my solutions.

After the installation I modified the My.ini as well

[mysqld]
datadir=C:/Program Files/MariaDB 10.6/data
port=3306
innodb_buffer_pool_size=1520M
old-mode=
character-set-server=utf8mb4
[client]
port=3306
plugin-dir=C:/Program Files/MariaDB 10.6/lib/plugin

the original file was:

[mysqld]
datadir=C:/Program Files/MariaDB 10.6/data
port=3306
innodb_buffer_pool_size=1520M
character-set-server=utf8
[client]
port=3306
plugin-dir=C:/Program Files/MariaDB 10.6/lib/plugin

Then in the code after connecting I run this query:
"SET character_set_results=utf8mb4"

It doesn't work instead to put the query in my.ini like this:

init-connect='SET character_set_results=utf8mb4;'

Thanks

Danilo