Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Unable to ® symbol output to MySQL

saqib
8 - Asteroid

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

1 REPLY 1
patrick_mcauliffe
14 - Magnetar
14 - Magnetar

@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

 

Labels