Have you tried this: SET ANSI_PADDING=OFF GO SELECT * FROM Foo
--- "Bitra, Venkateswararao (Corporate, consultant)" <[EMAIL PROTECTED]> wrote: > You are right its not an IBATIS question. I just needed to use > executeUpdate method to execute "SET ANSI_PADDING=OFF/ON" statement. > > -----Original Message----- > From: Ron Grabowski [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 26, 2005 9:15 AM > To: ibatis-user-java@incubator.apache.org > Subject: RE: ANSI_PADDING > > > How is this an IBatis question? It sounds like you need to contact > the > database vendor and find out how to turn it off. If you were using > straight JDBC, how would you turn padding off? > > --- "Bitra, Venkateswararao (Corporate, consultant)" > <[EMAIL PROTECTED]> wrote: > > We never required to turn it off. Because in Pervasive 8.6 by > default > > it was turned off. But in Pervasive 9 its turned on and we need to > > explicitly turn it off > > > > --Venkat > > > > -----Original Message----- > > From: Clinton Begin [mailto:[EMAIL PROTECTED] > > Sent: Sunday, April 24, 2005 3:38 PM > > To: ibatis-user-java@incubator.apache.org > > Subject: Re: ANSI_PADDING > > > > > > How do you turn it off without iBATIS? > > > > Clinton > > > > On 4/24/05, Bitra, Venkateswararao (Corporate, consultant) > > <[EMAIL PROTECTED]> wrote: > > > Hi, > > > I user IBATIS layer for my Pervasive SQL database. > > Pervasive SQL 9 came up with an option to deal with ANSI_PADDING > > problem with datatype CHAR and VARCHAR. ANSI_PADDING is on by > default > > in Pervasive. I need to "set ANSI_PADDING off" for all my > > transactions with Pervasive. Otherwise I have to trim all CHAR and > > VARCHARS. And when I use this trimming in my where clauses I loose > my > > indexing advantage. > > > How can I set this ANSI_PADDING off for all my > > transactions? Your help would be appreciated. > > > > > > thanks > > > > > > --Venkat > > > > > > > > >
