2 posts / 0 new
Last post
Change in Special Character Value in Oracle database
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 ?
Total votes: 2360

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.

Total votes: 2194