Return-Path: 
 <user-java-return-3424-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 80500 invoked from network); 23 Jul 2005 12:03:39 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 23 Jul 2005 12:03:39 -0000
Received: (qmail 20828 invoked by uid 500); 23 Jul 2005 12:03:35 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 20666 invoked by uid 500); 23 Jul 2005 12:03:33 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 20653 invoked by uid 99); 23 Jul 2005 12:03:33 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 23 Jul 2005 05:03:33 -0700
X-ASF-Spam-Status: No, hits=0.1 required=10.0
	tests=HTML_30_40,HTML_MESSAGE,RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of larry.meadors@gmail.com
 designates 64.233.162.204 as permitted sender)
Received: from [64.233.162.204] (HELO zproxy.gmail.com) (64.233.162.204)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 23 Jul 2005 05:03:27 -0700
Received: by zproxy.gmail.com with SMTP id s1so335924nze
        for <user-java@ibatis.apache.org>;
 Sat, 23 Jul 2005 05:03:31 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:references;
        b=dEuvoKRCnb/vOZY09I6OVS2bwAU5SkOruSMaC8acJnusNroNkKsYcaJmvDG3r/CUJVniOGMJY294rneMoDn4II6H4aV/Y+Tx6eCcYw3etaNeG04xQSEKcOXN/1GCBGzCTmv0+75eXHwNObgfrAP5odmOZydjn3XObcuUYvntRoQ=
Received: by 10.36.42.16 with SMTP id p16mr426315nzp;
        Sat, 23 Jul 2005 05:03:31 -0700 (PDT)
Received: by 10.36.118.10 with HTTP; Sat, 23 Jul 2005 05:03:31 -0700 (PDT)
Message-ID: <a10a823c050723050356e25c61@mail.gmail.com>
Date: Sat, 23 Jul 2005 06:03:31 -0600
From: Larry Meadors <larry.meadors@gmail.com>
Reply-To: lmeadors@apache.org
To: user-java@ibatis.apache.org
Subject: Re: problem with white space
In-Reply-To: <42DC14900000D54B@ims1c.cp.tin.it>
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1070_7251540.1122120211228"
References: <42DC14900000D54B@ims1c.cp.tin.it>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

------=_Part_1070_7251540.1122120211228
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

You might be able to use "select trim(someField) from table" to avoid this.

My guess is that this really has nothing to do with iBATIS, and everything=
=20
to do with the JDBC driver or database.

Larry


On 7/23/05, freeman@virgilio.it <freeman@virgilio.it> wrote:
>=20
> Hi,I'm new here, I'm not english therefore sorry for my writing. :)I=20
> use:1)
> Java2) My DBMS is Firebird 1.5My problem with iBATIS is consists:- when I
> extract varchar field java create a string as length as varchar, if real
> data is shorter than max value of varchar at end of string are pushed=20
> white
> space.Can I avoid that?Thank you.FreeMan
>=20
>=20
>

------=_Part_1070_7251540.1122120211228
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

You might be able to use &quot;select trim(someField) from table&quot; to a=
void this.<br>
<br>
My guess is that this really has nothing to do with iBATIS, and everything =
to do with the JDBC driver or database.<br>
<br>
Larry<br>
<br><br><div><span class=3D"gmail_quote">On 7/23/05, <b class=3D"gmail_send=
ername"><a href=3D"mailto:freeman@virgilio.it">freeman@virgilio.it</a></b> =
&lt;<a href=3D"mailto:freeman@virgilio.it">freeman@virgilio.it</a>&gt; wrot=
e:</span>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi,I'm new here, =
I'm not english therefore sorry for my writing. :)I use:1)<br>Java2) My DBM=
S is Firebird=20
1.5My problem with iBATIS is consists:- when I<br>extract varchar field jav=
a create a string as length as varchar, if real<br>data is shorter than max=
 value of varchar at end of string are pushed white<br>space.Can I avoid th=
at?Thank=20
you.FreeMan<br><br><br></blockquote></div><br>

------=_Part_1070_7251540.1122120211228--