This content has been marked as final. Show 10 replies
What is the database and national character set of your database?
Are you storing the data in VARCHAR2 or NVARCHAR2 columns?
What tool are you using to insert the data?
What tool are you using to retrieve the data?
What is the NLS_LANG setting on the client machine?
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.
Use dump() function to verify character data stored in the database.
actual text in column is 嗨，你怎么样？ in database.
When I execute this select dump(text) from multi_lang1 where rownum=1, I got the follwoing output.
Typ=1 Len=14: 85,232,255,12,79,96,96,14,78,72,104,55,255,31
For this one, select dump(text,1017) from multi_lang1 where rownum=1; i got the follwoing.
Typ=1 Len=14 CharacterSet=AL16UTF16: U,e8,ff,^L,O,`,`,^N,N,H,h,7,ff,^_
Instead, try: select text, dump(text, 1016) ...
Please answer Justin's questions completely, additionally you could tell us your OS. On all platforms SQL Developer is a good tool to check, are the characters stored correctly in the database.
This is the output for select dump(text,1016) from multi_lang1 where rownum=1------Typ=1 Len=14 CharacterSet=AL16UTF16: 55,e8,ff,c,4f,60,60,e,4e,48,68,37,ff,1f
My database is running on HPUNIX.
914416 wrote:Those seem to be valid codepoints, representing Han ideogram symbols.
As suggested earlier, use Oracle SQL Developer to verify characters stored.
I got the required result.. thanks to al..