The issue is discussed here:

http://www.sqljunkies.com/Forums/ShowPost.aspx?PostID=7978

and here:

http://sqljunkies.com/WebLog/odds_and_ends/archive/2005/09/12/16725.aspx

FWIW, our DBAs have ruled that CHAR(10) is max for char anything larger should be VARCHAR unless you KNOW the data will always have the same size.

>I am going to be moving some data from Visual FoxPro tables to SQL Server tables. The FoxPro tables have several character type columns defined as being 25 characters wide.
>
>I would appreciate any suggestions or pros and cons about moving this character type data into CHAR(25) or VARCHAR(25) columns in SQL Server.