Change your database schema (assuming you can) to use varchar.. With SQl Server 2k, there are very few reasons to use char versus varchar.. Save's space too!
Eric -----Original Message----- From: Chris Chew [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 2:50 PM To: [EMAIL PROTECTED] Subject: Trailing Spaces in SQL Server Fields Hello. I am new to turbine and working on my first app. I am using sql server 2000 (unfortunately), and the sun jdbc-odbc bridge driver. Whenever a new record is saved (INSERT or UPDATE), trailing spaces get added to the field value to fill up the maximum allowed. For example, everytime a user logs in, their username gets extended to the username + (32 - str.length(username)) spaces. That is, the user: 'turbine' becomes 'turbine ' And they can't log in again until I change it in the database. Can anyone offer any ideas of where and why this might be happening? Is likely it the driver, the peer service or the database? Thanks for the help, Chris __________________________________________________ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
