>>>> 2012/09/30 11:07 -0700, Mark Phillips >>>>
The data for this table comes from a web page (charet utf8). I copy/paste word files into
gedit (on linux) and then copy/paste from gedit to a text boxes on the web page input
form. I had thought I was stripping out all the funky characters by using a simple ascii
editor like gedit, but obviously not.
After looking at the mysqldump for the table in a hex editor, I discovered I have these
characters scatter throughout the body and intro columns:
How do you mean this? Is there an instance of Unicode character
LEFT DOUBLE QUOTATION MARK, or else of the string "“"?
In any case, this sounds like not an SQL, but general-programming problem; furthermore, I
suggest that you carefully select a left double quotation mark or any of the other
punctuation characters (RIGHT DOUBLE QUOTATION MARK, RIGHT SINGLE QUOTATION MARK, EM DASH,
HORIZONTAL ELLIPSIS, ...) that, it seems, you are getting and not liking, and carefully
follow your procedure.
It further seems to me that you really do not want that to be UTF-8 string, but ASCII, or