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

 

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.

 

Niels

 

________________________________

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.

 

Hi 

 

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=","
close=")">

          #regionCodeList[]#

        </iterate>                

      </isNotEmpty>

 

translates to

 

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

      

 

 

Thanks,

Prasad

 

DBO2 Inc

650-587-0106

 


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



Mime
View raw message