Zoho ODBC, "&" character gets changed

Zoho ODBC, "&" character gets changed

Postby 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.
Posts: 2
Joined: Thu 20 Apr 2017 23:43

Re: Zoho ODBC, "&" character gets changed

Postby 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" )
Devart Team
Posts: 788
Joined: Mon 06 Jul 2015 11:34

Return to ODBC Drivers