CodeIgniter Forums
Database Metadata - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forum-28.html)
+--- Forum: CodeIgniter 4 Discussion (https://forum.codeigniter.com/forum-31.html)
+--- Thread: Database Metadata (/thread-68672.html)



Database Metadata - petio - 08-11-2017

The method field_data in mysqli_driver on line 436 :
sscanf($query[$i]->Type, '%[a-z](%d)',
                $retval[$i]->type,
                $retval[$i]->max_length
            );

return the type of decimal fields like int
it is decimal (7,2)
it return $field->type is decimal 7

and mysqli comand SHOW COLUMNS FROM 'table' return type corectly

and for enum and set is the same


RE: Database Metadata - jarmen_kell - 08-11-2017

uuhh...... ok ??


RE: Database Metadata - skunkbad - 08-11-2017

If you need 7 to be 7.00:


PHP Code:
number_format7);