+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=31)
+--- Thread: Database Metadata (/showthread.php?tid=68672)
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_format( 7, 2 );