We are generating a text file from oracle database using the below procedure:
TEXT := UTL_FILE.FOPEN('DB_DIR',BOOKING_NUMBER||'_'||REC.CARD_NUMBER||'.txt','a', 32767);
UTL_FILE.PUT_LINE(TEXT,ORDERED_TEXT); --where ordered text is a CLOB colum
When we view the file in sql developer or Ultra edit the content appears correctly, whereas when we view the file in textpad or notepad, some junk character appears this is because that text is copy pasted from a word doc.
Database Characterset: NLS_CHARACTERSET UTF8
Database Version: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
We wanted to generate the text file without junk characters irrespective of copy pasted contents, could you please help.