UTF

From: Tony C.
Sent on: Thursday, January 28, 2010 8:39 AM
I am asking both bugzilla user's group and mysql this.

An employee here entered a bug into Bugzilla.  It had some posessives in 
the description of the bug (like "Gary's phone number is ...", etc).  
You can't have a single quote in a field in mysql I think because it
uses it to demarcate fields.  Anyway, Bugzilla translated it.  Later when
we tried to view the bug it gave an error about a malformed UTF code.

I created a temporary table, and selected just that record that was causing
problems into it, and then did a mysql dump of it to a file.  I notcied
several places where there should have been a ' or something else
non-printable it was stored as <FFFF> which I believe is 65535.  It was this
character that Bugzilla was choking on.  I just deleted each occurrence of
<FFFF> and did a mysql < file (file just had that one record).  Then I 
deleted the original record and selected it back from the table I had updated.

My question: are there any mysql tools/commands or bugzilla tools/commands
that will look for characters like that in the mysql database and delete
them?  Or will prevent them from going into the database to begin with?
Sanity Check in Bugzilla won't do it because I ran it and it said everything
was fine.

Any ideas?

Thanks

Tony


Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy