how to properly rectify database collation and charset ?

[qtwrk]

Hi,

 

I got a really really weird issue 

 

some times ago I attempt to migrate the site to MariaDB 10.6 , which it breaks due to the language is Spanish and some letters display messy ,  then if I do MariaDB 10.5 , it works fine 

 

here comes the weirdy , if I use AlmaLinux / Centos server + MariaDB 10.5 ,  it still works fine , however if I do Ubuntu 20.04 server + MariaDB 10.5  ,  it breaks 

 

on phpMyAdmin at both servers , I checked and compared the charset and collation , they are both same setting 

 

server env are mostly same as far I can tell , both are default Plesk installation , nothing is changed ,  db conf is also default settings 

 

so I am really scratching my hairs now , don't know what to check further.