Capncavedan/gist:8803953

Created February 4, 2014 13:55

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

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

Download ZIP

SQL to find data in a MySQL table that is non-ASCII

Raw

gistfile1.sql

	SELECT whatever
	FROM tableName
	WHERE columnToCheck <> CONVERT(columnToCheck USING ASCII)

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