I have legacy data that was stored in a MS SQL table in euc-kr character set. It all displays well on legacy pages that use the euc-kr character set. But we want to migrate everything to UTF-8.
I have migrated the table to MySQL and am trying to convert the characters to UTF-8.
In PHP, I can grab the data and convert it with: $Col2=iconv("EUC-KR","UTF-8",odbc_result($rs,"Col1")); and it displays correctly in UTF-8. But when I try to put it back into the database, the characters don't show as UTF-8.
I have tried the following directly in MySQL, but the data is not being saved in UTF-8 format: UPDATE TableName SET Col2=CONVERT(CONVERT(Col1 USING binary) USING utf8)
I have tried numerous combinations of euckr, latin1, utf8, binary- nothing works correctly.
I'm still fairly new to MySQL, so I'm hoping it's something trivial that I'm doing wrong. At least I hope so- I don't have much more hair left to pull out!