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)