Garbage in adhoc char columns

Hello all,

  If I launch the sentence:

     select '31' from dual

  using ADO in an COM+ componet (in a dllhost process), I get the 2 character string 31, in a recordset with a field of type adChar, with the properties DefinedSize=32 and ActualSize=2. This recordset is returned to the caller but there the field value expands to 32 characters (31 followed by GARBAGE) changing ActualSize to 32.

  It seems that this only happens with a COM+ component issuing the data request and with oracle 9.2.0.4 or 9.2.0.5 database server with NLS_LANG set to WE8ISO8859P15.

  A database with NLS_LANG set to WE8ISO8859P1 returns DefinedSize set to 2 although changing NLS_LANG in any instance has not been tested.

  żdoes anyone know how to handle that data query and do not get that trailing GARBAGE?   

  Thanks in advance. Received on Tue Mar 21 2006 - 06:13:46 CST