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.