Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 14660 invoked from network); 21 Nov 2007 19:24:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 21 Nov 2007 19:24:06 -0000 Received: (qmail 41824 invoked by uid 500); 21 Nov 2007 19:23:52 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 41809 invoked by uid 500); 21 Nov 2007 19:23:52 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 41798 invoked by uid 99); 21 Nov 2007 19:23:52 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Nov 2007 11:23:52 -0800 X-ASF-Spam-Status: No, hits=3.7 required=10.0 tests=DNS_FROM_OPENWHOIS,FORGED_HOTMAIL_RCVD2,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Nov 2007 19:23:55 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1IuvAc-00020Z-CU for user-java@ibatis.apache.org; Wed, 21 Nov 2007 11:23:34 -0800 Message-ID: <13884184.post@talk.nabble.com> Date: Wed, 21 Nov 2007 11:23:34 -0800 (PST) From: smelly To: user-java@ibatis.apache.org Subject: Re: about a space at the end In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: smelly_hulk@hotmail.com References: <13881815.post@talk.nabble.com> X-Virus-Checked: Checked by ClamAV on apache.org Please notice, the data type of column ACTIVE_IND is Char(1) and the value I get from retrieving is 'A '. There is a space at the end. Graeme J Sweeney wrote: > > On Wed, 21 Nov 2007, smelly wrote: > >> I am using ibatis and oracle 10. The jdbc driver is >> oracle.jdbc.driver.OracleDriver. When I retrieve data from table, I found >> a >> space ' ' is appended. Let's say column ACTIVE_IND CHAR(1), the data >> retrieved is 'A '. is it weird? Does anybody have idea? > > CHAR is a fixed length, so you get the padding. > > -- > Graeme - > > -- View this message in context: http://www.nabble.com/about-a-space-at-the-end-tf4851669.html#a13884184 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.