ASP:
P. Append cmd. CreateParameter ("parameter name", type, direction, size)
The parameter value types are as follows:
NAME value integer function
AdDBTimeStamp 135 Date and Time Data Type
AdDecimal 14 decimal integer
AdDouble 5 Double Precision small value
AdError 10 system error message
AdGUID 72 Globally unique identifier (Globally unique identifier)
AdDispath 9 COM/OLE Automatic Object (Automation Object)
AdInteger 3 4-byte signed integer
AdIUnknown 13 COM/OLE object
AdLongVarBinary 205 large 2-byte value
AdLongVarChar 201 large string value
AdLongVarWChar 203 large unencoded string
AdNumeric 131 decimal integer
AdSingle 4 single precision Floating Point decimal point
AdSmallInt 2 2-byte signed integer
AdTinyInt 16 1-byte signed integer
AdUnsignedBigInt 21 8-byte unsigned integer
AdUnsignedInt 19 4-byte unsigned integer
AdUnsignedSmallInt 18 2-byte unsigned integer
AdUnsignedTinyInt 17 1-byte unsigned integer
AdUserDefined 132 user-defined data type
AdVariant 12 OLE object
AdVarBinary 204 Double Byte variable value
AdVarChar 200 character variable value
Advarchar 202 unencoded string variable value
AdWchar 130 unencoded string
Note:
Ntext 203 adLongVarWChar
Text 201 adLongVarChar
In ASP, when a Command is used to call a stored procedure to add a record to a database, which type of parameter is used for ntext fields?
P. Append cmd. CreateParameter ("parameter name", 201, 1, 1073741823, cstr (value ))