SQL DATA TYPES

SQL DATA TYPES

SQL DATA TYPES

Data types and ranges for Microsoft Access, MySQL and SQL Server.

SQL DATA TYPES

Microsoft Access Data Types

Data type                Description                       Storage

Text                      Use for text or

                           Combinations of

                          text and numbers

                            255 characters

                                maximum

Memo                  Memo is used for

                            larger amounts of

                             text. Stores up to

                            65,536 character

                            Note: You cannot

                            sort a memo field

                              However they a

                                 searchable

SQL DATA TYPES

Byte            Allows whole                  1 byte

                   numbers from 0 to

                   255

Integer        Allows whole                   2 bytes

                   numbers between

                   32,768 and 32,7677

Long           Allows Whole                  4 bytes

                   numbers between

                   2,147,483 648 and

                   2,147,483,647

SQL DATA TYPES

Single          Single precision                 4 bytes

                     floating- point. Wil

                     handle most decimals

Double         Double precision               8 bytes

                     floating-point. Will

                     handle most decimals

Currency      Us for currency                  8 bytes

                     Holds up to 15

                     digits of whole

                     dollars, plus 4

                     decimal places

                     Tip: You can

                     choose which

                  country’s currency

                         to use

AutoNumber          AutoNumber fields               4 bytes

                              automatically give

                              each record its own

                              number, usually

                              starting at 1

Date/Time             Use for dates and                  8 bytes

                              times

Yes/No                 A logical field can                    1 bit

                             be displayed as

                             Yes/No, True/False,

                              or On/off. In code,

                              use the constants

                              True and False

                              (equivalent to-1

                              and 0) Note Null

                              values are not

                              allowed in yes/no

                              fields

Ole Object                    Can store pictures,               up to

                                      audio, video, or                    1GB

                                      other BLOBs

                                      (Binary Large

                                         OBjects)

Hyperlink                       Contain links to

                                      other  files,

                                      including web

                                      pages

Lookup                          Let you type a list                 4 bytes

Wizard                          of options, which

                                     can then be chosen

                                     from a drop-down

                                     list