ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From smelly <smelly_h...@hotmail.com>
Subject Re: about a space at the end
Date Wed, 21 Nov 2007 19:23:34 GMT

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.


Mime
View raw message