PRB: AppendChunk from ADO or RDS Doubles Binary Field Size
Article ID: 200261
Article Last Modified on 6/24/2004
APPLIES TO
- Microsoft Active Server Pages 2.0
- Microsoft Active Server Pages 3.0
- Microsoft Internet Information Server 4.0
- Microsoft Internet Information Services 5.0
- Microsoft ActiveX Data Objects 2.5
- Microsoft ActiveX Data Objects 2.6
- Microsoft ActiveX Data Objects 2.7
This article was previously published under Q200261
SYMPTOMS
When you use AppendChunk from either ADO or Remote Data Service (RDS) from scripting (JScript or Visual Basic(r) Scripting Edition) to update a binary field, the result is twice as large as the original.
CAUSE
In scripting, all data types are considered Variant and therefore default to Unicode.
RESOLUTION
Call AppendChunk from within a Component Object Model (COM) object that is written in a language that supports data types other than Variant.
Keywords: kbdatabase kbprb KB200261