Changing charset from latin2_bin to utf8 and back erased all data that starts with "special" character

Question

I changed charset from latin2_bin to utf8 in one of the columns in my table to fix sorting problem. It didin't hwlp and in addition to that, when i switched back to latin2_bin all records have same bug

łokacinski -> empty
środek -> empty
ośrodek -> o
czółko -> cz

so if the surname start with special(polish) character it's been completly deleted and if the special character is in the middle, i ve got only characters before special character. I didint think something so silly would erase that much data... Anyone can help?

score 0 · Answer 1 · answered Sep 02 '20 at 05:20

0

You used the wrong conversion technique.

Here is a list of typical issues, and fixes for each http://mysql.rjweb.org/doc.php/charcoll#fixes_for_various_cases

For further help, please provide SELECT HEX(col), ... as mentioned in Trouble with UTF-8 characters; what I see is not what I stored .

"Erased" sounds like the "truncated" case that I discuss. Please provide an example.

answered Sep 02 '20 at 05:20

Rick James

135,179
13
127
222

I tried to HEX it and it showed empty data. So it really somehow erased data. Lucky for me, i found backup from 2 days before, so im saved. – Arkadiusz Polak Sep 04 '20 at 13:02
One of the scenarios "truncates" the data, thereby losing text. – Rick James Sep 04 '20 at 17:24

Changing charset from latin2_bin to utf8 and back erased all data that starts with "special" character

1 Answers1