Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
1 4
Impact
~7k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
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