I am moving a text file into a BO and am getting some errors on certain characters from a note type field. If I just do an import through MySQL the error says: Invalid utf-8 character string.
This seems to be happening when someone has entered a contraction: e.g. instead of entering "it is" they entered "it's".
When I look at the txt file in a text editor it shows the following:
"...Says it x92s the only way for them..."
Pasted into this text box the text shows:
"...Says itӳ the only way for them ..."
The text should say:
"...Says it's the only way for them..."
Which is what it actually shows in the program the data came from.
I am guessing this has something to do with the encoding used in the program this came from.
The question though is how do I deal with it when I am importing it into MySQL and Aware?
Thanks,
Jim