Find a Windows-1252 char in mysql column

There's a row that I believe contains a Windows-1252 smart-quote char in a particular column that is messing up a user of this table. How can I select an开发者_如何学Goy row that contains any Windows-1252 punctuation in this column?

AND it would be really cool if I had a way of converting these values if I redefine the column as being utf8 (it's currently latin1).

The table structure already defines which charset is used in each column. So if you have a column using Windows-1252, then every text inside will be using Windows-1252. I would recomment changing the encoduing of your columns explicitly (easily done with phpMyAdmin).

Use charset=iso-8859-1 no MySQL.