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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-01 : 17:51:14
|
Charles writes "When a varchar field is part of a client-side cursor/result set that is created via an ODBC call, does ODBC pad the varchar (to the max length) when returning the result? Specifically, I am trying to determine if using a varchar 254 rather than a char 30 (just in case I might someday need it) carries a network performance penalty.
Other info:
I am using ADO in VB 6 to create web classes in Win 98/NT4.
SQL Server 7 on NT 4.0 sp6.
From simple testing it appears that MS Access after it receives the data always pads the result and that FoxPro pads to the length of the largest row in the result set. (I admit my testing was pretty skimpy.)"
|
|
|
|
|
|
Varchar padded in ODBC?