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 > > > > >
