I am getting errors from the FreeTDS ODBC driver when trying to send text from Zapier to MS SQL Server 2012 (SP4-GDR).
If any special characters (such as æ, ø and å) which are regular characters in Danish and hard to avoid in address information, are sent.
When using “Find Row via Custom Query” I get:
(pyodbc.ProgrammingError) ('42000', " [FreeTDS][SQL Server]Unclosed quotation mark after the character string 'K'.
In this case because there is a text string that includes the letter ‘ø’ after the K. So FreeTDS cuts off the statement right when it meets the character and then thinks there was no closing quotation mark.
I don’t think I can control the Client Charset from within Zapier, since the driver sits at Zapier, but does anyone have an idea how I can fix this?
Best answer by steph.nView original