Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Sign in to follow this  

how to properly rectify database collation and charset ?

Recommended Posts



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.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this