>Hi all,
>I have a question regarding the storing and retrieving of character data into and from Oracle. Given that I have this table in Oracle:
>

>MyTable.MyField Varchar2(10) NOT NULL
>

>
>From an updateable view in VFP, these behaviors are observed.
>

>select vw_MyTable
>append blank
>replace MyField with 'X' && will send and store 'X         ' to Oracle.
>tableupdate()
>* and such
>requery('vw_MyTable')
>? len(MyField) && 10
>? MyField + "YZ" && 'X        YZ'
>

>
>This example shows that VFP padded the spaces when the data was sent to Oracle. Is there a way (maybe a setting) that will autotrim the data when sending back to Oracle? VFP9 solution is acceptable.
>The desired results will be:
>1. Data is sent/stored in Oracle as 'X' with no spaces padded, thereby optimizing physical data storage - which is the reason for the Varchar2 Oracle data type.
>2. Data comes back (as it is right now) as C(10).

try, into the datasession:

CURSORSETPROP("MapVarchar",.T.,0)