I'm migrating database tables to SQL 2000 from Access 2000. I have a Description field that is defined in SQL as a char (500) field. I've figured out that SQL 2000 automatically fills up the field with spaces, and for some reason that causes some odd things to happen. Mainly, in a multi-line text box, I get line breaks in unexpected places. Surprisingly enough, I'm NOT getting any errors saying I've entered too many characters or anything like that when I try to edit the field, but it is displaying strangely. And I know that if I change the display using Trim() or RTrim I will have an un-editable control.
Is there a different way I should define the field in SQL or Access that will eliminate this trailing space? Or something else I'm not considering?
Thanks in advance