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!

SQL query not retrieving special characters in like O’, M÷ and û

533281Oct 18 2008 — edited Oct 22 2008

Hi,

I have a sql script to query database. The output is a string. When I execute this script through a Korn shell script to send the query result to a .csv file, it is showing some characters of the output as below.

The characters O’ is displayed as ?
The characters M÷ is displayed as ?
The characters û is displayed as u

I am able to retrieve the data as it is while running the script through SQL * Plus and spooling the output to a .csv file.

If anybody is having solutions for this please reply.

Thanks in advance for your kind help

Regards,
Sreesha

Edited by: user530278 on Oct 18, 2008 2:56 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 19 2008

Added on Oct 18 2008

7 comments

1,741 views