[prev in list] [next in list] [prev in thread] [next in thread] 

List:       dbi-dev
Subject:    Re: Oracle & Trailing Blanks - possible change in DBD::Oracle
From:       Tim Bunce <Tim.Bunce () ig ! co ! uk>
Date:       1999-07-30 22:41:45
[Download RAW message or body]

    *** From dbi-users -- To unsubscribe, see the end of this message. ***

Your use of SQL_CHAR will protect you. No change.

Tim.

On Fri, Jul 30, 1999 at 01:26:40PM -0500, Bruce Albrecht wrote:
> I don't understand the type 1 vs. type 5 issues, but here's something
> I do all the time:
> 
> Oracle table has column that's CHAR(N).
> 
> I do query with placeholders, and bind a perl variable with bindtype =
> SQL_CHAR.  The perl variable contains a string that is normally < N
> chars, so if this change means that I'll have to check the precision
> of the field and add trailing blanks to the value being bound to make
> it exactly N characters in order to get equality matches, this will
> affect me.
> 
> Tim Bunce writes:
>  > Looking at this issue again I've discovered that the key issue is that
>  > type 1 strips trailing blanks whilst type 5 doesn't.
>  > 
>  > I'rather m concerned by this. Since I'm against the DBI changing the
>  > data in any way on principle and since Oraperl used to use type 5
>  > I'm strongly considering changing DBD::Oracle 'back' to using type 5.
>  > 
>  > This would only affect anyone who relies on placeholders having
>  > trailing blanks stripped off. (I'll provide a way to alter the
>  > default with a single statement and/or env var for anyone affected).
>  > 
>  > If that's you - speak up now!

------------------------------------------------------------------------------
To unsubscribe from this list, please visit: http://www.isc.org/dbi-lists.html
If you are without web access, or if you are having trouble with the web page,
please send mail to dbi-users-request@isc.org with the subject line of
'unsubscribe'.
------------------------------------------------------------------------------

[prev in list] [next in list] [prev in thread] [next in thread]