Data Types
Field Types
Access 2000 SQL Server Oracle 8 Summary
Text Up to 255 characters
Char Fixed-length non-Unicode character data with a maximum length of 8,000 characters.
Char Fixed length character data of length size bytes. Maximum size is 2000 bytes. Default and minimum size is 1 byte.
VarChar Variable-length non-Unicode data with a maximum of 8,000 characters.
VarChar2 Variable-length character string having maximum length size bytes. Maximum size is 4000, and minimum is 1. You must specify size for a VARCHAR2
nChar Fixed-length Unicode data with a maximum length of 4,000 characters.
nChar Fixed-length character data of length size characters or bytes, depending on the choice of national character set. Maximum size is determined by the number of bytes required to store each character, with an upper limit of 2000 bytes. Default and minimum size is 1 character or 1 byte, depending on the character set.
nVarChar Variable-length Unicode......
Join Now or Login to view the rest of this paper.
Approximate Word Count: 1016
Approximate Pages: 4 (260 words per double-spaced page) |