Re: How to correct corrupted UTF-8 characters
Posted by: James Cobban
Date: October 23, 2010 04:26PM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to correct corrupted UTF-8 characters
2162
October 23, 2010 04:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.