I accidentally changed the encoding of a field from UTF-8 to macroman, after switching back to UTF-8, all Chinese characters were scrambled up, is there any chance I can reverse the process? or the change is permanent ?
Asked
Active
Viewed 37 times
2
-
Have you checked here? https://stackoverflow.com/questions/17559659/converting-mac-roman-character-to-equivalent-utf-8 – Ryosaku Sep 15 '17 at 10:22
-
By "field" you mean a table column? – deceze Sep 15 '17 at 10:23
-
yes, by field i meant a column – user3500286 Sep 15 '17 at 10:28
-
Probably the data is destroyed. But, just in case it is not, please provide `SELECT HEX(col) FROM ...` for a sample. And tell us what Chinese characters it should represent. If you get is hex `3F`, the Chinese is lost. Also, what step(s) did yo use when converting to `macroman`? – Rick James Sep 15 '17 at 19:55
-
did REPAIR TABLE help? – Channa Aug 31 '21 at 06:37