Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Microsoft Jet data types (Read 1359 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Microsoft Jet data types
17.08.14 at 13:00:08
 
Microsoft Jet data types
 
4.0 Jet type nameOLE DB DBTYPEMaximum size (4.0)3.5 type name
BitDBTYPE_BOOLBit
BigBinaryDBTYPE_BYTES4000 bytesn/a
ByteDBTYPE_UI1Byte
CurrencyDBTYPE_CYCurrency
DateTimeDBTYPE_DATEDateTime
DecimalDBTYPE_NUMERIC28 digits (base 10)n/a
DoubleDBTYPE_R8Double
GUIDDBTYPE_GUIDGUID
LongDBTYPE_I4Long
LongBinaryDBTYPE_BYTES1073741823 bytesLongBinary
LongTextDBTYPE_WSTR536870910 charactersLongText
ShortDBTYPE_I2Short
SingleDBTYPE_R4Single
VarBinaryDBTYPE_BYTES510 bytesBinary
VarCharDBTYPE_WSTR255 charactersText

 
 
Source:
http://msdn.microsoft.com/en-us/library/windows/desktop/ms713678%28v=vs.85%29.as px
Back to top
 
« Last Edit: 17.08.14 at 13:12:55 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Microsoft Jet data types
Reply #1 - 22.08.14 at 15:41:22
 
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1