Skip navigation links

MySQL Forums :: Character Sets, Collation, Unicode :: How to correct corrupted UTF-8 characters


Advanced Search

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
How to correct corrupted UTF-8 characters 3432 James Cobban 10/05/2010 08:59PM
Re: How to correct corrupted UTF-8 characters 1207 Rick James 10/06/2010 10:13PM
Re: How to correct corrupted UTF-8 characters 1120 James Cobban 10/23/2010 03:37PM
Re: How to correct corrupted UTF-8 characters 1618 James Cobban 10/23/2010 04:11PM
Re: How to correct corrupted UTF-8 characters 1760 James Cobban 10/23/2010 04:26PM
Re: How to correct corrupted UTF-8 characters 2163 Rick James 10/26/2010 11:20PM


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.