Zoho ODBC, "&" character gets changed

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
Posts: 2
Joined: Thu 20 Apr 2017 23:43

Zoho ODBC, "&" character gets changed

Post by haojiang11 » Tue 02 May 2017 18:49


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.

Devart Team
Posts: 1551
Joined: Mon 06 Jul 2015 11:34

Re: Zoho ODBC, "&" character gets changed

Post by MaximG » Thu 04 May 2017 10:45

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" )

Post Reply