Zoho ODBC, "&" character gets changed
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.