how should varChar fields be described to ADO?



Hi,

I wonder if someone could authoritatively clarify the official ruling
on adVarChar? According to this site and a couple of (non-MS) books
I've looked at adVarChar comes with the following warning "A string
value (Parameter object only)"

http://www.w3schools.com/ado/prop_field_type.asp

No such warning found here...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdcstdatatypeenum.asp

Also if I create a Record Set from a SQL Server table that has a
varChar(20) column, the type of that field in VB6 is returned as 200
(adVarChar).

We're a data source provider and are trying to verify that it is
correct to in all cases to return varChar as the type to ADO, when
that is the stored column type.

Thanks,
Eric
.