RE: Truncating trailing spaces - looking for alternative solution s

From: Will Rutherdale (Will.Rutherdale_at_sciatl.com)
Date: 01/21/05

  • Next message: Michael A Chase: "Re: Truncating trailing spaces - looking for alternative solutions" 
    To: dbi-users@perl.org
Date: Fri, 21 Jan 2005 12:02:10 -0500

    I don't understand the problem statement. Are you experiencing undesired
    truncation, or are you wishing to have strings truncated but not getting it?

    The ChopBlanks attribute on a database handle or statement handle controls
    truncating of fixed char columns, as documented in the DBI man page.

    I'm just an average Perl DBI user. If it's a deeper problem than this, let
    us know so the more expert users can solve the problem.

    -Will

    -----Original Message-----
    From: Chad Terry [mailto:chazzz1976@yahoo.com]
    Sent: Friday 21 January 2005 11:19
    To: dbi-users@perl.org
    Subject: Truncating trailing spaces - looking for alternative solutions

    Greetings -
    Having the notorious problem where trailing spaces are being truncated from
    bind variables. I have found two solutions, one is to rtrim the column in
    the SQL statement, the other is to set the type to CHAR with bind_param. The
    problem is, I will be looking at changing up to 100 standalone scripts. I'm
    wondering if something else can be done in the environment or setup. This
    only started happening to us after we upgraded our environment to more
    current versions of Perl, DBD, and DBI. Can somone explain what it was in
    this upgrade that would start causing this to happen?

    We went from:
    Perl 5.00404
    DBI .90
    DBI.pm 1.83
    DBD .47
    DBD.pm 1.6
    Oracle.pm 1.47 1997/09/08

    We went to:
    Perl 5.6.0
    DBI 1.32
    DBI.pm 11.23
    DBD 1.14
    DBD.pm 11.11
    Oracle.pm 1.1 2002/07/05

    We are running Oracle 8i database on AIX 5. Perl environment also on AIX 5.

    I appreciate any thoughts or suggestions on this issue.

    Thanks,
    Chad Terry

         - - - - - - - Appended by Scientific-Atlanta, Inc. - - - - - - -
    This e-mail and any attachments may contain information which is confidential, proprietary, privileged or otherwise protected by law. The information is solely intended for the named addressee (or a person responsible for delivering it to the addressee). If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete it from your computer.

  • Next message: Michael A Chase: "Re: Truncating trailing spaces - looking for alternative solutions"

    Relevant Pages