Hence, varchar is usually preferable since it doesn't add spaces to your data. That being said, I generally use an unlimited length text column wherever possible.

I have an MS SQL 2005 database, and a FileMaker 10 client accessing it via ODBC (SQL Native Client) The data I am trying to import is (varchar (max), null).