111 reputation
14
bio website
location Pennsylvania
age 27
visits member for 1 year, 7 months
seen Dec 4 '13 at 16:11

Jun
16
awarded  Notable Question
Dec
3
awarded  Popular Question
Sep
18
comment Tell MySQL to start using utf-8 encoding without `convert to`ing it
To correct a single field that's already utf8 encoded to proper latin1: UPDATE table_name SET field=CONVERT(CONVERT(field USING binary) USING utf8) WHERE id = 12345;
Jan
24
awarded  Scholar
Jan
24
accepted Tell MySQL to start using utf-8 encoding without `convert to`ing it
Jan
24
comment Tell MySQL to start using utf-8 encoding without `convert to`ing it
Thanks! This led me to the correct solution, especially the helpful link you posted. I answered my own question describing my exact strategy (as well as posting a script to automate the conversion).
Jan
24
answered Tell MySQL to start using utf-8 encoding without `convert to`ing it
Jan
24
awarded  Supporter
Jan
22
awarded  Student
Jan
22
asked Tell MySQL to start using utf-8 encoding without `convert to`ing it