Data::Type::Collection::DB - types from databases
valid ' ' x 20, DB::VARCHAR( 20 ); valid '2001-01-01', DB::DATE( 'MYSQL' ); valid '16 Nov 94 22:28:20 PST', DB::DATE( 'DATEPARSE' ); valid '9999-12-31 23:59:59', DB::DATETIME; valid '1970-01-01 00:00:00', DB::TIMESTAMP; valid '-838:59:59', DB::TIME; valid '2155', DB::YEAR; valid '69', DB::YEAR(2); valid '0' x 20, DB::TINYTEXT; valid '0' x 20, DB::MEDIUMTEXT; valid '0' x 20, DB::LONGTEXT; valid '0' x 20, DB::TEXT;
Common types from databases. All vendor-specific types should have a special prefix. Example:
DB::TIME DB::MYSQL::TIME DB::ORA::TIME
flexible date
DATE() emulates MYSQL builtin datatype
Date::Parse
date and time combination
Mysql
long text
medium text
set of strings
"BLOB" sized dataset
time
[RANGE] ('-838:59:59' to '838:59:59')
timestamp
[RANGE] ('1970-01-01 00:00:00' to sometime in the year 2037)
tiny text
string with a limited length
year
The allowable values are 1901 to 2155, 0000 in the 4-digit year format, and 1970-2069 if you use the 2-digit format (70-69) (default is 4-digit)
Sourceforge http://sf.net/projects/datatype is hosting a project dedicated to this module. And I enjoy receiving your comments/suggestion/reports also via http://rt.cpan.org or http://testers.cpan.org.
Murat Uenalan, <muenalan@cpan.org>
To install Data::Type, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Data::Type
CPAN shell
perl -MCPAN -e shell install Data::Type
For more information on module installation, please visit the detailed CPAN module installation guide.