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