Issue with sqlplus [message #544564] |
Wed, 22 February 2012 09:23 |
gajini
Messages: 262 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 |
cookiemonster
Messages: 13938 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 #544570 is a reply to message #544564] |
Wed, 22 February 2012 10:17 |
|
Michel Cadot
Messages: 68687 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:
Regards
Michel
-
Attachment: OraFAQ.JPG
(Size: 2.91KB, Downloaded 3065 times)
[Updated on: Wed, 22 February 2012 10:17] Report message to a moderator
|
|
|