| character sets [message #285689] |
Wed, 05 December 2007 05:31  |
shachipathak
Messages: 16
Registered: December 2007
Location: Bangalore
|
Junior Member |
|
|
I have a database with characterset settings as UTF8 .
I have stored some chinese characters.
But when i query it in SQL toad i find it is fetched in Invereted Questionmarks (?).
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: character sets [message #286496 is a reply to message #285899] |
Fri, 07 December 2007 10:50  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
As far as I know (I may be wrong), TOAD doesn't have multi-byte display capability.
The first step is usually to confirm that the characters you inserted are correclty stored in the DB - else - only the client that inserted them is likely to be able to see them when it queries the data.
Your client's NLS_LANG setting should match (be compatible with) your machine's characterset - not the database's UTF8 characterset.
Once you know what bytes represent your characters in UTF8 characterset, confirm that your data is stored using those bytes in the table.
select dump(my_column, 1010) Decimal, dump(my_column, 1016) Hex_bytes from my_table where...
You have the best chance of seeing your characters correctly either using a Java based tool (maybe like Oracle's free SQL Developer) or a browser based tool (like iSQLplus or Oracle's Apex). This is because browsers and Java have extensive characterset support built into their design.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
