on these types are by default the full length of the data stored.
10
10
The only difference between the two types is the COLLATION which is
11
11
used. VARBINARY uses a binary collation for all index usage. VARCHAR can only
12
contain valid UTF-8 characters.
12
contain valid UTF-8 characters. If you need to store ASCII values the VARBINARY type.
13
13
14
14
-------------
15
15
TEXT and BLOB
26
26
---------
27
27
28
28
BIGINT and INTEGER exist as Drizzle's two integer numerical types. BIGINT is
29
a 64bit integer while INTEGER is a 32bit integer.
29
a 64bit integer while INTEGER is a 32bit integer. Declaring a numerical types as UNSIGNED the value to be 64bit.
30
30
31
31
DOUBLE is the systems native double type.
32
32
42
42
43
43
DATE
44
44
45
TIME
46
47
TIMESTAMP can be supplied an optional parameter of (6) during creation. This causes microseconds to be recorded as well. The TIME type represents duration of an event in seconds.