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!

CHR(151) and CHR(191) are displaying the same character in Oracle 10g

500334Mar 21 2006 — edited Jun 19 2006

Hi,

currently we migrated to Oracle 10g from oracle 8i client. We had a problem in our application that when big hypen is sent as part of input parameter to database stored procedure, the big hypen is been replaced with inverted question in the database. We tried to check the same by running the below query

select chr(151) and chr(191) fron dual;

To our surprise same character is display for the both that is inverted question mark.

Is there any solution to overcome this.

Thanks in advance for your help.

Thanks,
Ravikiran.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 17 2006

Added on Mar 21 2006

5 comments

3,690 views