Error importing Text File

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
Jhstephenson
Posts: 297
Joined: Wed Apr 22, 2015 11:44 pm

Error importing Text File

Post by Jhstephenson »

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
Post Reply