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