Skip to content

Instantly share code, notes, and snippets.

@walkerdigital

walkerdigital/sanitize.sql

Created January 12, 2018 16:07
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save walkerdigital/6bc3e56ef9b2ace9395e897788e383d4 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save walkerdigital/6bc3e56ef9b2ace9395e897788e383d4 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. walkerdigital created this gist Jan 12, 2018.
    1 change: 1 addition & 0 deletions sanitize.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    UPDATE `table` SET `field` = CONVERT(BINARY CONVERT(`field` USING latin1) USING utf8);