I haven't experienced this on Access or SQL Server 2000. What database are you using? What version of IBatisNet are you using? Could you supply us with a small snippet of the xml mapping that returns a padding value? It sounds like something is getting changed into a CHAR as opposed to a VARCHAR.
--- paul <[EMAIL PROTECTED]> wrote: > I have recently worked on transferring an existing project across to > iBatis.NET. The reason I am writing is that the same SQL run in > iBatis has > VARCHAR values padded to there full database data type length - while > the > direct SQL via ADO returns the stored value at its "correct" length. > > Why is this? How do I ensure the QueryForList returns the values > without > padded? > > Kind Regards > > Paul Neumeyer > > > Random Sea Pty Ltd > T: 02 9939 1988 > M: 0418 400 656 > [EMAIL PROTECTED] > > > +------------------------------------------------------------------------+ > This email may contain information which is privileged or > confidential. > If you are not the intended recipient of this email, please notify > the > sender immediately and delete it without reading, copying, storing, > forwarding or disclosing its contents to any other person. Thank > you. > +------------------------------------------------------------------------+ > >
