SuN-80/fix-utf8.sql

Created February 20, 2018 12:53

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/SuN-80/05d3ccb49d55034f06794c5550ac4524.js"></script>
Save SuN-80/05d3ccb49d55034f06794c5550ac4524 to your computer and use it in GitHub Desktop.

Download ZIP

Fix double-encoded UTF8 characters

Raw

fix-utf8.sql

	-- In an utf-8 table
	UPDATE mytable SET
	field = CONVERT(CAST(CONVERT(field USING latin1) AS BINARY) USING utf8);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment