반응형

www.w3schools.com/asp/ado_datatypes.asp

 

ADO Data Types

ADO Data Types The table below shows the ADO Data Type mapping between Access, SQL Server, and Oracle: DataType Enum Value Access SQLServer Oracle adBigInt 20   BigInt (SQL Server 2000 +)   adBinary 128   Binary TimeStamp Raw * adBoolean 11 YesNo Bit  

www.w3schools.com

 

TEXT type adLongVarChar

.Parameters.Append .CreateParameter("TEXTATA", adLongVarChar, adParamInput, len(TEXTDATA), TEXTDATA)    

 

NVARCHAR type adVarWChar

.Parameters.Append .CreateParameter("USERID", adVarWChar, adParamInput, 100, USERID)

반응형
Posted by Hippalus

댓글을 달아 주세요