RE: ANSI_PADDING
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
Re: ANSI_PADDING
Please tell us how you would accomplish this with straight JDBC. You never really answered Clinton's question. Brandon On 4/29/05, 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
RE: ANSI_PADDING
Need to use executeUpdate(SET ANSI_PADDING=OFF,null) method of SQLMAP class before executing any sql statement and ofcourse after starting a transaciton. -Original Message- From: Brandon Goodin [mailto:[EMAIL PROTECTED] Sent: Friday, April 29, 2005 9:14 AM To: ibatis-user-java@incubator.apache.org Subject: Re: ANSI_PADDING Please tell us how you would accomplish this with straight JDBC. You never really answered Clinton's question. Brandon On 4/29/05, 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
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
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