I have a batch process copying data from TPS to MySQL table. For a couple of records I’m getting an error
Record Insert Error,An error was experienced during the creation of a record.|File: StanMag|Error: Incorrect string value: ‘\x81 …’ for column
myfield at row 1 (S1000)
This is a string field containing some descriptive information, I suspect end users may be copying content from a website or word document containing unicode characters.
How can I quickly remove these before assigning field values?