ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Niels Beekman" <ni...@wis.nl>
Subject RE: turning off prepending the 'N' character.
Date Sat, 18 Jun 2005 09:03:19 GMT


This has to do with the way the queries are translated to prepared
statements. So this has nothing to do with iBATIS, it's your driver that
does this, check the documentation of the driver. Btw, this does not
affect the results of the query, so there is nothing to worry.





From: Narasimha Prasad [mailto:prasadn@dbo2.com] 
Sent: zaterdag 18 juni 2005 1:01
To: user-java@ibatis.apache.org
Subject: turning off prepending the 'N' character.




I observed that when queries are constructed by ibatis, it prepends a
character 'N' to the parameters.   Is there a way to turn this off ?


Eg: (Say regionCodeList contains two regions, East and West)


      <isNotEmpty prepend="AND" property="regionCodeList">

        Project.regionCode IN

        <iterate open="(" property="regionCodeList" conjunction=","





translates to


AND Project.regionCode IN  ( N'REGION_EAST', N'REGION_WEST'  )







DBO2 Inc



No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.7.8/22 - Release Date: 6/17/2005

View raw message