#19 Problems with ADOdb Lite data types

Current release
open
nobody
(General) (10)
5
2009-05-30
2009-05-30
Andrew Gregory
No

The data type mapping in the ADOdb Lite driver (gladius_datadict.inc) is missing support for 'DT':

case 'DT': return 'DATETIME';

Also, the ADOdb Lite documentation states that the 'X' type is capped to 4000 characters, and the 'XL' should be the largest possible. Accordingly, the following changes should be made:

case 'XL': return 'VARCHAR(65000)';
case 'X': return 'VARCHAR(4000)';
case 'X2': return 'VARCHAR(4000)';

Discussion