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 <epugh@upstate.com> 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:edfairfaxvere@yahoo.com]
> Sent: Friday, April 26, 2002 2:50 PM
> To: turbine-user@jakarta.apache.org
> 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:turbine-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail:
> <mailto:turbine-user-help@jakarta.apache.org>
>
>
> --
> To unsubscribe, e-mail:
> <mailto:turbine-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail:
> <mailto:turbine-user-help@jakarta.apache.org>
>
__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
--
To unsubscribe, e-mail: <mailto:turbine-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:turbine-user-help@jakarta.apache.org>
|