MariaDB不会更改数据库的排序规则

I have been researching this problem on StackOverflow for more than 24 hours and decided that this isn't already covered elsewhere even though there are many Q&A about the same topic.I have been researching this problem on StackOv