|
Current Topic: View Topic Tree |
Everything > Science & Technology > Computers > Programming > SQL |
|---|
|
|
VARTEXT |
|
|
FLOAT |
|
|
INT |
|
|
VARCHAR |
|
|
DATE |
In the SQL programming language, VARTEXT is NOT a valid data type. The following are commonly used data types:
FLOAT - used to hold a single-precision floating point number.
INT - used to hold an integer number.
VARCHAR - used to a hold a small text string within a fixed number of characters.
TEXT - used to a hold a variable length text string of up to 64K characters.
DATE - used to hold a date with a format of YYYY-MM-DD in the range of 1000-01-01 to 9999-12-31.