Unable to ® symbol output to MySQL

[saqib]

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

[patrick_mcauliffe · Accepted 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