Home » SQL & PL/SQL » Client Tools » Issue with sqlplus
Issue with sqlplus [message #544564] Wed, 22 February 2012 09:23 Go to next message
gajini
Messages: 250
Registered: January 2006
Senior Member
Hi All,

When I execute this select query, the special character "'"(single quote) is getting displayed properly in TOAD
but it not getting displayed properly when I execute it in sqlplus from my database server(HP-UX).Database version is 10.2.0.4.
Please let me know how to fix this issue issue in server.

Actual Value: Driver's Side

Display Value in SQLPLUS
Quote:
SQL> select * from temp_char;

ID
-------------------------------------------------------------
Vehicles Driver?s Side Floor



Many Thanks.
Re: Issue with sqlplus [message #544565 is a reply to message #544564] Wed, 22 February 2012 09:27 Go to previous messageGo to next message
cookiemonster
Messages: 11072
Registered: September 2008
Location: Rainy Manchester
Senior Member
It's not a standard single quote then. Use the dump function to get the ascii value of the character so you can work out what it really is.
Re: Issue with sqlplus [message #544566 is a reply to message #544565] Wed, 22 February 2012 09:36 Go to previous messageGo to next message
gajini
Messages: 250
Registered: January 2006
Senior Member

Thanks. Please let me know how it is getting displayed properly when using TOAD.
Re: Issue with sqlplus [message #544567 is a reply to message #544566] Wed, 22 February 2012 09:39 Go to previous messageGo to next message
cookiemonster
Messages: 11072
Registered: September 2008
Location: Rainy Manchester
Senior Member
It's using a different character set I assume.
Re: Issue with sqlplus [message #544568 is a reply to message #544567] Wed, 22 February 2012 09:44 Go to previous messageGo to next message
gajini
Messages: 250
Registered: January 2006
Senior Member

Thanks. Please let me know if there is any possibility to achieve the same thing with sqlplus also.
Re: Issue with sqlplus [message #544569 is a reply to message #544568] Wed, 22 February 2012 09:46 Go to previous messageGo to next message
cookiemonster
Messages: 11072
Registered: September 2008
Location: Rainy Manchester
Senior Member
Yes. Read up on character sets. I'm not an expert in the area, others here know more.
Re: Issue with sqlplus [message #544570 is a reply to message #544564] Wed, 22 February 2012 10:17 Go to previous message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
2 possibilities:
1/ You have a different NLS_LANG for both tools
2/ Your SQL*Plus does not handle this character - but most likely in this case it should display a black square like:

./fa/9881/0/

Regards
Michel


  • Attachment: OraFAQ.JPG
    (Size: 2.91KB, Downloaded 278 times)

[Updated on: Wed, 22 February 2012 10:17]

Report message to a moderator

Previous Topic: Unable to connect database.
Next Topic: TOAD 8.6 and Oracle 10g - cannot connect
Goto Forum:
  


Current Time: Wed Oct 22 08:28:26 CDT 2014

Total time taken to generate the page: 0.09481 seconds