This content has been marked as final. Show 6 replies
You have to double-check your O/S configuration. The fact that you set LANG to UTF-8 does not mean that your terminal or terminal emulation (fonts, keyboards) actually works in UTF-8. You should verify both the settings used for SQL*Plus and the settings used by the editor/viewer that you use to verify the file contents.
To check the SQL*Plus configuration, first store the value in a column and use SQL function DUMP(column,1016) to look at the stored codes. If they are correct, e.g. in UTF-8, send the value to the library. Then, use
od -t x1 <file>
to look at the codes. If the codes are still UTF-8 codes, the problem is with your file viewer. If the codes are incorrect already in the column, your SQL*Plus session is not really working in UTF8 (input terminal issue).
I suspect either the input terminal or the file viewer work in KOI-8R.
the problem was with my viewer. When I open file by windows notepad it's ok.
But when I run Linux command $cat <file> I get bad characters too. WHY ?
And HOW can I setup Linux environment variables for correct view ?
Check MOS doc [url https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=264157.1&blackframe=1]The correct NLS_LANG setting in Unix Environments Doc ID: 264157.1
You need to check the setup of your terminal.
Yes it's terminal settings. Thank you very much !