Hello,

Got a problem where I am losing spaces from strings stored in my database.

For example if I have a string field which has the following text in it 'Monkies ' and I connect a db aware component in delphi directly to that field then it will display as 'Monkies' without the space at the end.

I've tried this with a new delphi application containing nothing more than a TOracleSession, TOracleDataSet, TDataSource to get the data, using the simplest of queries to get nothing but the exact field from an exact record. And I`ve tried displaying it on a form using a TDBText, TDBEdit, TDBMemo and they all do exactly the same thing.

If if add to the query to include a second field a the length the the problem field then it will show as 8 (correct) but if I add a calculated field to the dataset in delphi then it show as 7.

It seems as though there is a Trim being done when the data is retrieved but I can' find an option to turn that off.

It's causing a real problem where I need to be able to see the space.

Any help or suggestions would be appreciated cheers...

(Delphi 2009 on Windows7)