SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert SQL - Substitutes Hypen with Special Chars

Srini MadOct 28 2016 — edited Oct 28 2016

Version:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

We have two instances (SIT & UAT) where are running an insert SQL. When the same SQL is run on the two instances, we find that the insert is good in SIT - but in UAT, we find special charcters to replace "hypen".

Example: In SIT, the value is "ATTENTION – REPLY NEEDED: Request - [ Case ID : #caseID ]"

But in UAT, the same gets inserted as "ATTENTION �� REPLY NEEDED: Request - [ Case ID : #caseID ]"

Any help on what could be causing this difference when the same script is run?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 25 2016

Added on Oct 28 2016

7 comments

840 views