Automatically trim trailing spaces in MS Sql Server

[Colin Kilburn <co...@accesstec.ca>]

Hi All,

I can't find anything about this in the archives or by googling, but I 
can't be the first to want to do this...

Data in a CHAR column is padded with spaces.  This is fine for storage, 
but how can I tell sql server or OJB that I don't want the trailing 
spaces when I retrieve the column or any column in a select statement?  
The usual solution offered in other forums is to do a 
RTRIM(some_char_column), but I'm not sure how to achieve that in OJB.

I'm hoping this is a simple JDBC connection parameter or something that 
would ideally cover all database queries.  Can anyone point me in the 
right direction?

Thanks in advance,
Colin


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org