Skip to content

Instantly share code, notes, and snippets.

@walkerdigital

walkerdigital/sanitize.sql

Created January 12, 2018 16:07
Show Gist options
  • Save walkerdigital/6bc3e56ef9b2ace9395e897788e383d4 to your computer and use it in GitHub Desktop.
Save walkerdigital/6bc3e56ef9b2ace9395e897788e383d4 to your computer and use it in GitHub Desktop.
Download ZIP
Clean MySQL field of hidden formatting / characters (ie. Microsoft Word)
Raw
sanitize.sql
UPDATE `table` SET `field` = CONVERT(BINARY CONVERT(`field` USING latin1) USING utf8);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment