Change the type of a column
Default:
This is useful for changing datetime/timestamp columns to type date, or logical to integer. We use the ADODB type codes. If a number or integer is forced to date or timestamp, then we assume that the number is a Unix timestamp.
C: character and varchar types
X: text or long character (eg. more than 255 bytes wide).
B: blob or binary image
D: date
T: timestamp
L: logical (boolean)
I: integer
J: positive integer (>= 0)
N: numeric (float, double, money)
P: positive numeric (>= 0.0)
Note that we do not modify the field types in your database. This property is for display and data entry type checking purposes only.Syntax
# change col1 to type 'D' for date
$lens->forceType = 'col1^D'; Basic:Yes Advanced/Enterprise:Yes DynamicEdit:Yes [Version 1.3]
|