IDS Forum

Re: Return trailing spaces-stored procedure

Posted By: Art Kagel
Date: Thursday, 16 September 2010, at 8:37 a.m.

In Response To: Re: Return trailing spaces-stored procedure (SPASO LAZAREVIC)

If you create a small ESQL/C program and fetch the result column/field into
a 'fixchar' or 'char' type host variable VARCHAR and LVARCHAR type columns
and function returns will retain any "real" trailing spaces but CHAR type
columns or returns will be space padded to their full defined length (the
difference is that the char type host variable will be NULL terminated so
you have to allow an extra byte in the length of the variable for the NULL)
but if you fetch the data into a 'string' type host variable then the
trailing spaces in a CHAR type column or return field will be stripped. For
a VARCHAR or LVARCHAR type column or function return field the "real" spaces
will not be stripped from any of these types.

IB that ODBC behaves as if the char host variables were ESQL/C "string"
types. That will mean that, as others have pointed out, you may have to use
VARCHAR or LVARCHAR to see the trailing spaces in the host variables.
However, other host languages, say Visual Basic or Perl, may treat the
incoming data differently and there, most likely, lies your problem.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.

On Thu, Sep 16, 2010 at 6:27 AM, SPASO LAZAREVIC <spasobn@gmail.com> wrote:

> Thanks Art, I figure out, but I need to prove it.
>
> For backup purpose, beside from returning value from sp, I insert data into
> db
> table and I got the same result. Data are without trailing blanks.
>
> In db I create field with varchar and char type.
>
> Some other system call my sp so I expect answer from them to find what they
> receive (with or without trailing blanks).
>
> I user AGS Server Studio for manipulating sp's and for viewing results from
> my
> sp.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--0016362835ceb9440704905fb43f

Messages In This Thread

• Return trailing spaces-stored procedure
  SPASO LAZAREVIC -- Thursday, 16 September 2010, at 5:03 a.m.
  • Re: Return trailing spaces-stored procedure
    John Miller iii -- Thursday, 16 September 2010, at 5:19 a.m.
    • Re: Return trailing spaces-stored procedure
      SPASO LAZAREVIC -- Thursday, 16 September 2010, at 5:35 a.m.
  • Re: Return trailing spaces-stored procedure
    Fernando Nunes -- Thursday, 16 September 2010, at 5:45 a.m.
  • Re: Return trailing spaces-stored procedure
    Art Kagel -- Thursday, 16 September 2010, at 5:53 a.m.
    • Re: Return trailing spaces-stored procedure
      SPASO LAZAREVIC -- Thursday, 16 September 2010, at 6:27 a.m.
      • Re: Return trailing spaces-stored procedure
        Art Kagel -- Thursday, 16 September 2010, at 8:37 a.m.
    • Re: Return trailing spaces-stored procedure
      Fernando Nunes -- Thursday, 16 September 2010, at 6:33 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.