This content has been marked as final. Show 10 replies
This is my database details:
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
I'm storing data in NVARCHAR column. If I insert data using insert statement, junk values(?????) are inserted in to that column. So I used " for update" statement and I pasted the require text in that column. Then i wrote simple plsql block to display that values, it is giving junk values again. Please help me to display as it is in database.
914416 wrote:Those seem to be valid codepoints, representing Han ideogram symbols.
As suggested earlier, use Oracle SQL Developer to verify characters stored.