When I replicate a record with Address field value as like – 401 West “A” Street, Suite 200 in Salesforce, I get the value – 401 West A Street, Suite 200 in my Oracle database.
What might be causing this as the value in the database is different from the original value ?
Please use the query, SELECT * FROM V$NLS_PARAMETERS;
to find the parameter NLS_CHARACTERSET
NLS_CHARACTERSET value is set to something else on your Oracle database instance i.e, something like NLS_CHARACTERSET = US7ASCII. Please use a different value that is suitable like NLS_CHARACTERSET = AL3UTF8. This will resolve the issue.
