Find a Windows-1252 char in mysql column

Question

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 any 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).

Answer 1

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).