Cakephp 3.* shows blank instead of 0

Graziel · October 24, 2017, 5:06am

tintInt with length 1 is mapped to boolean:

cakephp/cakephp/blob/f0e61d9b665249eef415e9749e8506e82e53fdc7/src/Database/Schema/MysqlSchema.php#L99


    if (strpos($matches[2], ',') !== false) {
        list($length, $precision) = explode(',', $length);
    }
    $length = (int)$length;
    $precision = (int)$precision;
}


if (in_array($col, ['date', 'time', 'datetime', 'timestamp'])) {
    return ['type' => $col, 'length' => null];
}
if (($col === 'tinyint' && $length === 1) || $col === 'boolean') {
    return ['type' => TableSchema::TYPE_BOOLEAN, 'length' => null];
}


$unsigned = (isset($matches[3]) && strtolower($matches[3]) === 'unsigned');
if (strpos($col, 'bigint') !== false || $col === 'bigint') {
    return ['type' => TableSchema::TYPE_BIGINTEGER, 'length' => $length, 'unsigned' => $unsigned];
}
if ($col === 'tinyint') {
    return ['type' => TableSchema::TYPE_TINYINTEGER, 'length' => $length, 'unsigned' => $unsigned];
}

Topic		Replies	Views
Cakephp 3 mysql column zerofill not working Need Help	1	992	October 25, 2017
Database nullable integer field has value 'NULL', cakephp displaying '0'	10	1347	January 20, 2022
Cakephp 3.x show me empty row with my custom query news	0	768	August 8, 2016
Cant set width of a table column with style option	2	2107	June 15, 2016
CakePHP 3.8.10 released! Announcements news , release	0	635	February 24, 2020

Cakephp 3.* shows blank instead of 0

Releases

Documentation

Community

Cakephp 3.* shows blank instead of 0

Related topics

Releases

Documentation

Community