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
