Retrieving and inserting a space character

[syi129]

Hi

I seem to have a problem retrieving and inserting a space character into oracle. DOA 4.0.7 seems to change any whitespace character to NULL.
I am not sure why DOA does this. The DOA source code seems to do something like if (DataSet.TrimString(Field.Value) = '')then Field = NULL;

Does anyone know of way to retrieve whitespace characters from a DOA OracleDataset? Do I have to change it to use a package component to make it work?

 

[Marco Kalter]

You can disable the TOracleSession.Preferences.TrimStringFields option to prevent that trailing blanks are removed from dataset field data.

 

[syi129]

thanks that seems to be working now. I didn't think it would be a session level privilege. I guess I missed one when I was looking through the code