The TOracleQuery component will never automatically trim the field contents, it will always retrieve exactly what is in the database. It cannot be used with data-aware components like the TOracleDataSet though, so it is of limited use.

There is no option to control TrimStringFields behavior at the dataset level. You can only do so at the TOracleSession level.


Marco Kalter
Allround Automations