This content has been marked as final. Show 7 replies
Trung Hieu wrote:do you have a data storage or data presentation problem?
Hello all,i have problem with chinese character , i have oracle DB machine (using oracle linux and oracle DB 11g) and on client machine (window XP) i've used sql developer to connect to oracle DB , but i can't display chinese character , when i selected , it only show *¿¿¿¿¿¿¿¿¿¿¿¿¿¿* charcter,
please help me
SELECT ASCIISTR(CHINESE_COL) FROM CHINESE_TABLE WHERE ID = 1;
above will reveal if correct characters actually reside within the DB.
the result is "\00BF" , what should i do now ?
i also set NLS_LANG = simple chinese in .bash_profile and on client machine (XP) has installed chinese package too,but it's till show ¿¿¿¿¿¿¿¿ character when i select in my table
What is the characterset of your database?
(Refer to nls_database_parameters)
Senior Oracle DBA
Read1 person found this helpful
Which Character Set Supports Which Language [ID 62421.1]
I usually prefer the dump function, like this:1 person found this helpful
select col, dump(col, 1016) from table where suitable_condition_to_pick_row ... ;
Also check you terminal / ssh client software character set translation where you work... for full details see these - matching your env.1 person found this helpful
[url https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=179133.1 ]MOS: The correct NLS_LANG in a Windows Environment Doc ID: 179133.1
[url https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=264157.1]MOS: The correct NLS_LANG setting in Unix Environments Doc ID: 264157.1