filtered data on AsString

[osa]

Hi,

I put some data to simple string field in Oracle DB. Data are correctly stored, I can check it with SQL Explorer.

When I need read it, with TOracleDatase, and I use
dataset.FieldByName('FIELD').AsString then I get filtered result. As data was stored string aaa#13#13#13 and last 3 characters (#13) are not read with dataset.FieldByName('FIELD').AsString

Can anybody help?

thanks, osa

 

[Marco Kalter]

If you want to receive the exact data, including trailing spaces and cr/lf pairs, you need to disable TOracleSession.Preferences.TrimStringFields. This only affects the TOracleDataSets connected to that session.

 

[osa]

thanks, works fine

osa