I am designing a web site with a sql server 7 backend. Right now I am just typing the info into the fields in the tables, but I am finding that when I do this, it is putting extra spaces at the end of what I typed in. Does anyone know why this would be happening and how to stop it? It is throwing off all my statements trying to populate the web site. Thanks in advance for the help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Extra spaces when entering data
- Thread starter chillay
- Start date
By chance, are your fields defined as Char(SomeNumber).
That is the default behvior for char fields. I recommend you change the data type to varchar. Doing so will remove the extra spaces.
-George
Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
That is the default behvior for char fields. I recommend you change the data type to varchar. Doing so will remove the extra spaces.
-George
Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
- Thread starter
- #4
- Status