OraFAQ Forum: Client Tools » character sets

Home » Other » Client Tools » character sets (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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 (?).

Report message to a moderator

Re: character sets [message #285693 is a reply to message #285689]

Wed, 05 December 2007 05:41

Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Check your NLS settings on yuor client, on TOAD configuration.

Regards
Michel

Report message to a moderator

Re: character sets [message #285695 is a reply to message #285693]

Wed, 05 December 2007 05:44

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.

Report message to a moderator

Re: character sets [message #285697 is a reply to message #285695]

Wed, 05 December 2007 05:48

Michel Cadot
Messages: 68637
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

Report message to a moderator

Re: character sets [message #285706 is a reply to message #285697]

Wed, 05 December 2007 06:18

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.

Report message to a moderator

Re: character sets [message #285708 is a reply to message #285706]

Wed, 05 December 2007 06:21

Michel Cadot
Messages: 68637
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

Report message to a moderator

Re: character sets [message #285899 is a reply to message #285689]

Thu, 06 December 2007 00:44

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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic:	where java.exe that make "SQL Developer" work in 11g
Next Topic:	Commit after each DML

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 17:02:27 CDT 2024