I have some legacy mysql files of the format frm, MYI and MYD that i wish to export to csv. Using sequel pro on OSX, i created a new database and copied those files over.
All the data can be accessed fine but i have major issues with the query results due to unknown encoding. I have no idea what format the previous programmer used.
This database contain English, Chinese, Japanese and Korean song titles but as i have no idea what format these names are encoded in, so i get weird characters using utf8 format:
ÄÐÉù ÂèÂèºÃ+Éµ´ó½ã+ÆÃË®¸è Àä¿ÕÆøµÄ¶À°× À¶É«µÄÃÎ
Most of them begins with A with an accent though, i wonder if they do provide any clue as to which encoding format the programmer used.
I've tried putting these text onto safari/chrome browser and ran through the various encoding options but to no avail.
Will anyone please help me?