selecting spaces from Oracle

[rinoshjoseph]

Hello

Is there any way to retrieve spaces from Oracle. For eg. (A particular field in Oracle has 5 spaces(' '). While I am retrieving TOracledataset gives ''. Is there any properties to set for getting spaces)
Please help

Thanks

 

[jpickup]

Look at TOracleSession.Preferences.TrimStringFields

 

[rinoshjoseph]

Thank u