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