LMSouq
database Open

How to change the CHARACTER SET (and COLLATION) throughout a database?

JE
Jeg Bagus
1 month ago
3 views
Problem Description
Our previous programmer set the wrong collation in a table (Mysql). He set it up with Latin collation, when it should be UTF8, and now I have issues. Every record with Chinese and Japan character turn to ??? character. Is possible to change collation and get back the detail of character?

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base