[please notice that I have used "_" as blanks in the following text]
Can anyone tell me a simple question I am aksing to myself ?
When I run the following query in Toad :
SELECT 'Test' FROM DUAL
I get a result grid with [Test____________________________] as a result. The size of the cell data is 32 chars and 28 blanks have been added in the end of the string. If I do the same using another database client, I don't get those blanks.
I saw the following option in Toad : "Trim string data in CHAR and NCHAR columns". I tried to activate it and when I run the query the blanks are removed. But when I explicitely add a blank in the end of the string, it is also removed. Example
SELECT 'Test______' FROM DUAL
I get a result grid with [Test] as a result. But I don't want blanks to be removed.
I don't understand why Toad has such a behaviour.
Is there a way to tell Toad not to change results and keep the original string I have in my query ?
Thank you for your help.