Home » SQL & PL/SQL » Client Tools » character sets (oracle 10g)
character sets [message #285689] Wed, 05 December 2007 05:31 Go to next message
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 #285693 is a reply to message #285689] Wed, 05 December 2007 05:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check your NLS settings on yuor client, on TOAD configuration.

Regards
Michel
Re: character sets [message #285695 is a reply to message #285693] Wed, 05 December 2007 05:44 Go to previous messageGo to next message
shachipathak
Messages: 16
Registered: December 2007
Location: Bangalore
Junior Member
but i have tried checking the samething on the sql prompt.
still i see some vague data.
Re: character sets [message #285697 is a reply to message #285695] Wed, 05 December 2007 05:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
vague?

You mean you don't how to interpret them.
Maybe if you post them we can do it.
Don't forget to format you post.

select value from v$nls_parameters where parameter = 'NLS_CHARACTERSET';


Regards
Michel
Re: character sets [message #285706 is a reply to message #285697] Wed, 05 December 2007 06:18 Go to previous messageGo to next message
shachipathak
Messages: 16
Registered: December 2007
Location: Bangalore
Junior Member
the problem is not about interpretation but the data come in some special characters which are not readable.
Re: character sets [message #285708 is a reply to message #285706] Wed, 05 December 2007 06:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post what I asked.
Check what I suggested.
That's all I have to say.
You don't want then You're On Your Own (YOYO).

Regards
Michel
Re: character sets [message #285899 is a reply to message #285689] Thu, 06 December 2007 00:44 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:

data come in some special characters which are not readable


There is different between data come and data display/show. Your problem is related to display/show.
Re: character sets [message #286496 is a reply to message #285899] Fri, 07 December 2007 10:50 Go to previous message
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.
Previous Topic: where java.exe that make "SQL Developer" work in 11g
Next Topic: Commit after each DML
Goto Forum:
  


Current Time: Sat Dec 10 16:21:25 CST 2016

Total time taken to generate the page: 0.12548 seconds