Fields fill up with spaces

[Steve Roberts]

I have a simple table with ID, Project, and Keyword fields(SQL Server 7.0
latest SPs). The Project and Keyword fields are Char 100 allow nulls. When I
enter anything in either field then try to go back and add to the field it
gives me an error that the field is full. When I select everything to the
right of what I originally typed the field appears to be full of spaces. I
can delete the spaces, add more characters to the field but when I go back
to edit it again the field is filled up with spaces again. This occurs if I
use a form or just enter it directly to the table.

Any Ideas of what is causing this?

Thanks

Steve

 

[Razvan Socol]

Hi, Steve

Change the data type to varchar(100) instead of char(100).

Razvan

 

[Steve Roberts]

That fixed it. Why would Char cause that problem?


Thanks

 

[Philipp Stiefel]

That fixed it. Why would Char cause that problem?

Char is by definition a fixed length datatype. If you don't
enter enough data to fill the field, it is filled up with
blanks.

Cheers
Phil