Skip to Main Content
Forums

SQL Developer

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!

Export format in text file(encoding)

3556676Sep 28 2017 — edited Sep 28 2017

Hi,

After running an SQL query, I am getting query-results as shown below.

pastedImage_0.png

Please note the highlighted block.

  • 1st highlighted block has small super script '2' in each cell. This is 'square' sign.
  • 2nd highlighted block has the word : 'TZA/00/M/LAC50—B30/WD/001' . Please notice the character after 'TZA/00/M/LAC50'. Its called em dash(—).

I am trying to export this result into a delimited text file. I have tried following two formats.

pastedImage_6.png

Problem:

  1. In Format 1 i.e. with 'ASCII' encoding, I am getting the symbol '?' in place of both characters (The square symbol & the em-dash).
  2. In Format 2, I.e. with 'UTF-8' encoding, I am able to get the square symbol(the superscript). But the in second block, the em-dash is not coming at all. It is coming like 'TZA/00/M/LAC50B30/WD/001'.

Is there any way, I can get these characters in exported text file. Please note that I need to export the data in text file only with 'delimited' format only. What may be proper encoding here.

This is urgent. Please help me.

Best Regards,

Priyank
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2017
Added on Sep 28 2017
#sql, #sql-developer
4 comments
2,935 views