Devart Forums

Hello,

When I execute an INSERT or UPDATE through Zoho ODBC that has a value of "&", it translates "&" to "&" For example:
UPDATE Accounts SET "Account Name" = 'Smith & Sons"
I found the Account Name becomes "Smith & Sons" in Zoho.
However, if I edit the Account Name in the Zoho website and type in "Smith & Sons", the "&" character does not get changed, and remains "&".

Is there a way to stop this ODBC behavior, and let the & character remain as &?

I found this also happens to double quote, "<" and ">" characters.

Thank you.

Thank you for the information. We reproduced the problem and fixed this error. The fix will be included in the next ODBC Driver for Zoho CRM build. If necessary, we can send you a night build of the driver that includes this fix. You can send the request in this case using the e-support form : ( https://www.devart.com - menu "Support"\"Request Support" )