Problem retrieving varchar2 columns, different tools [message #282642] |
Thu, 22 November 2007 19:55 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
j10021213
Messages: 4 Registered: November 2007
|
Junior Member |
|
|
We have a problem querying one of our 9i databases when connecting to it using an 8i client.
1. When using SQL Plus, varchar2 columns seem to have extra spaces in them (e.g. ' H E L L O').
2. When using TOAD, varchar2 columns don't show up at all as if they were blank. Also upon connection we're getting a ORA-12571 error.
3. When using SQL Worksheet there are no problems at all.
Also in cases 1 and 2 a simple query like select 'hello' from dual just returns a blank value.
Which is weird since the other databases we have on the server are just fine.
Any ideas? We're rather stumped by this.
|
|
|
|
|
|
Re: Problem retrieving varchar2 columns, different tools [message #282985 is a reply to message #282983] |
Sun, 25 November 2007 21:19 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
j10021213
Messages: 4 Registered: November 2007
|
Junior Member |
|
|
Quote: | When you get different results it is because SOMETHING is DIFFERENT!
|
Yeah, I know something is different. That's why I came to these forums to find someone who can help us figure out what that SOMETHING is. There's no need to be so sarcastic.
All the tools were running with the same version of the 8i client, same oracle home as there is only one version of the client installed on the PC I was testing on. All databases have same versions.
Quote: | We can NOT solve this situation for you because only you have YOUR environment!
|
I wasn't asking you to. Read my first post. I was merely asking for ideas. A push in the right direction. Trying to see if someone has similar experiences.
|
|
|
|
Re: Problem retrieving varchar2 columns, different tools [message #283003 is a reply to message #282987] |
Sun, 25 November 2007 22:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
j10021213
Messages: 4 Registered: November 2007
|
Junior Member |
|
|
Quote: | #1 - You insist that everything is the same.
#2 - You know you have different results.
|
I already said I know something is different. All I said was the tools were running on the same client and the databases are of the same version. That leaves a lot of things where something could be different.
Look, I'm not here to debate OK? And since you're the only who seems to be replying so far anacedent, do you know of any specific reason the queries behave as they do? Or of any specific scenario where such is possible?
That's all I'm asking.
|
|
|
Re: Problem retrieving varchar2 columns, different tools [message #283016 is a reply to message #283003] |
Sun, 25 November 2007 23:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
The client applications are different.
Seems you have some UTF8/Unicode settings.
1/ SQL*Plus blanks are in place of 00 code point. SQL*Plus 8i does not support ITF8/Unicode
2/ Seems your TOAD does not know how to communicate
3/ SQL*Plus Worksheet (Java) supports Unicode.
Check your environment for language and character set settings.
Regards
Michel
[Updated on: Sun, 25 November 2007 23:30] Report message to a moderator
|
|
|