Today i got a new requirement that I need to insert japanese and chinese words in database to capture address details for region specific.
After that, I need to display those words in report as well. I inserted those other language into database. but I could not display it.. While displaying im getting ??????? as output.
Please assist me. thank you
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.
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
Those seem to be valid codepoints, representing Han ideogram symbols.
As suggested earlier, use Oracle SQL Developer to verify characters stored.