nix, shell, perl, php, mysql and mac os x tips and tricks

Monday, December 11, 2017

Find all non-ascii characters in MySQl column 

SELECT *
  FROM products 
 WHERE DESCRIPTION <> CONVERT(DESCRIPTION USING ASCII)
Posted by Rory at 12:40 PM
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)