If the data has a ® sysmbol I get the following error msg:
Error: Output Data (17): DataWrap2ODBC::SendBatch: [MySQL][ODBC 8.0(w) Driver][mysqld-5.7.14-google-log]Incorrect string value: '\xAE' for column 'Business' at row 1 Insert into.............
I am using UTF-8 on the mySQL DB
Solved! Go to Solution.
@saqibTry to use the function ConvertToCodePage. I believe that symbol is UTF-16, so you've have to convert the field.
https://help.alteryx.com/11.3/index.htm#Reference/Functions.htm?Highlight=codepage