RE: turning off prepending the 'N' character.

Sat, 18 Jun 2005 02:05:39 -0700

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:[EMAIL PROTECTED]
Sent: zaterdag 18 juni 2005 1:01
To: [email protected]
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

Reply via email to