Hello, maybe SET ANSI_PADDING ON/OFF can help you (but i don't think so). We had the same problem and decided to use VARCHAR columns and have no problems with it.
Regards Max > -----Urspr�ngliche Nachricht----- > Von: Colin Kilburn [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 16. Juli 2003 20:43 > An: OJB Users List > Betreff: Automatically trim trailing spaces in MS Sql Server > > > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
