Re: How to correct corrupted UTF-8 characters

[James Cobban]

I am getting farther:

I had not issued SET NAMES 'utf8'. When I do I get:
mysql> select location, hex(location), length(location), char_length(location) from tblLR where idlr=23320;

| N Cor E ½ Lot 16 Con 4, Caradoc, Middlesex, ON, CA | 4E20436F72204520C2BD204C6F7420313620436F6E20342C2043617261646F632C204D6964646C657365782C204F4E2C204341 | 51 | 50 |

mysql> select location, hex(location), length(location), char_length(location) from tblLR where idlr=23319;

| N ½ E ½ lot 18 con ?, Adelaide, Middlesex, ON, CA | 4E20C382C2BD204520C382C2BD206C6F7420313820636F6E203F2C204164656C616964652C204D6964646C657365782C204F4E2C204341 | 55 | 51 |

So now all I have to do is remove all of the capital A with caret characters from the file, and add the "SET NAMES 'utf8'" to my.cnf on my web server. How do I do the first?