Thanks for your reply, Eric. The schema is already set as VARCHAR(32). I modified the mysql schema that comes with the tdk to work with MSSQL, which basically meant changing TIMESTAMP's to DATETIMES and using a more complex "IF EXISTS" statement.
Any other ideas? Thanks, Chris --- Eric Pugh <[EMAIL PROTECTED]> wrote: > 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]> > __________________________________________________ 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]>
