On Fri, 11 Oct 2002 12:21:27 +0200 Swen Schillig <[EMAIL PROTECTED]> wrote:
> Just curious, is ChopBlanks not supposed to affect the column specifiers in > the where clause as well ? > I just saw that only the output columns are trimmed > so any clause like ............where <string-field> like '%dog' is not > working if <string-field> = 'mad-dog ' > > Os is this a "bug" in the driver (I'm using the DB2 driver). ChopBlanks only affects the returned values. Comparisons in the WHERE clause are completely internal to the database. In some databases you can affect the comparison method (space padded or not) by assigning a type to the placeholder with bind_param() or bind_param_inout(). -- Mac :}) Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
