OCI: Trailing spaces of strings cut off via input bind

"André Hartmann" <andrehartmann_at_hotmail.com> schrieb im Newsbeitrag news:a48vcm$bi3$1_at_crusher.de.colt.net...
> Hi there,
>
> I have the following strange behaviour when I try to insert CHR-values
> into a NOT NULL chr column:
>
> * created table with
>
> create table abc (test char not null)
>
> ... works fine.
> * inserted something with:
>
> insert into abc values(' ')
>
> ... works fine.
>
> * then executed
>
> insert into abc values(?)
>
> .. and bind ? to ' ':
>
> char* pValue = new char;
> *pValue = ' ';
>
> swdReturnCode = OCIBindByPos (
> (OCIStmt*) pOCIStatement,
> (OCIBind**) &pBindHandle,
> (OCIError*) pConnection->getOCIError(),
> (ub4) 1,
> (dvoid*) pValue,
> (sb4) (pValue == NULL) ? 0 : 1,
> (ub2) SQLT_CHR,
> (dvoid*) NULL,
> (ub2*) NULL,
> (ub2*) NULL,
> (ub4) NULL,
> (ub4*) NULL,
> (ub4) OCI_DEFAULT
> );
>
>
> ... now when I OCIExecute, i get:
>
> ORA-01400: cannot insert NULL into ("<user>"."ABC"."TEST")
>
> .. why is this ??? why is my ' ' converted to an empty string which equals
> NULL ?????? Any help ? Is there some magic removing blanks in OCI ????
>
> Andre
> :(
>
>
>

... after further testing, let me re-formulate the problem. When I insert a CHAR or VARCHAR value into a column with an input bind variable through OCI, trailing spaces (blanks, ASCII 32) are being cut off. leading spaces are not cut off, training line breaks, tabs and so on are not cut off as well. Please help me, this is nasty.

André
:( Received on Tue Feb 12 2002 - 00:31:40 CST