Skip to Main Content

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!

UTF symbols not spooled in csv file

Uday_NAug 12 2020 — edited Aug 12 2020

Hi All,

           I am writing a query which have

Select  emp_id ,  '£' || emp_salary  as Salary from employee .

Employee:

Emp_id  emp_salary

1                4000

2              5000

When i run the query and export to csv file through spooling in sql plus , i found it displayed as

emp_id Salary

1       ,  ?4000

2       , ?5000

I even tried by saving file by using Encoding as UTF 8 in Notepad++ and try to spool the output into the file. It didn't work ?

Could any one kindly advise .

Regards,

Uday

Comments
Post Details
Added on Aug 12 2020
6 comments
481 views