Hello my dear friends,
I have a challenging question for you. Here are the facts:
I did not know this, but UTF8 and UTF16 are not compatible, apparently you can't have a data connection of different encoding. Trying to pull data from the Smartsheet table throws the error below.
As I understand, I need to convert either of those data sources to the other UTF encoding. Either convert the CustomSQL source to UTF16, all of it. Or convert the Smartsheet to UTF8 somehow.
I would like not to have an intermediary solution like putting the data in an Excel sheet, since that requires periodic manual maintenance. Or if you happen to have a fully automatable method, that would be great.
I would appreciate any suggestions, I have not found a means to mass-convert these things, the CONVERT commands I found have only limited power to convert - one string at a time, but I need to convert everything.
Thank you and god bless.