ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gilles Bayon" <ibatis....@gmail.com>
Subject Re: Perofrmance problem Ibatis 1.2/.NET 2.0/SQL SERVER 2000
Date Mon, 13 Nov 2006 20:52:20 GMT
Which Ado code do you used ?
By default if you use this code in ADO

parameter.DbType = DbType.String;

ADO will send this parameter as nvarchar(XX), you must specify the SqlDbType
to VarChar to send it as VarChar

With iBATIS to sent a Sql Server VarChar SqlDbType, used the attribute
dbType="VarChar"

>
-- 
Cheers,
Gilles

<a href="http://www.amazon.com/gp/registry/6JCP7AORB0LE ">Wish List</a>

Mime
View raw message