Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 varchar padding in ODBC

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-01-30 : 08:17:14
John writes "I'm told that using large varchar fields is a bad idea because during the handling of the data between the database and my program it will get padded to full size by ODBC, making the network use inefficient. This seems unlikely to me. Is it true?
On the other hand, if no padding occurs anywhere, why bother to make any varchar field less than the maximum size?"
   

- Advertisement -