<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
I've been trying to fix the <a
href="http://sourceforge.net/tracker/?func=detail&aid=3441722&group_id=23067&atid=377411">bug
#3441722</a> and I have few questions.
I've stored descriptions in /libraries/data_mysql.inc.php:<br>
<br>
$cfg['ColumnTypesDescription'] =
!empty($cfg['ColumnTypesDescription'])<br>
? $cfg['ColumnTypesDescription']<br>
: array(<br>
'TINYINT' => 'A very small integer. The signed range is
-128 to 127. The unsigned range is 0 to 255.',<br>
'SMALLINT' => 'A small integer. The signed range is
-32768 to 32767. The unsigned range is 0 to 65535.',<br>
'MEDIUMINT' => 'A medium-sized integer. The signed range
is -8388608 to 8388607. The unsigned range is 0 to 16777215.',<br>
'INT' => 'A normal-size integer. The signed range is
-2147483648 to 2147483647. The unsigned range is 0 to 4294967295.',<br>
'BIGINT' => 'A large integer. The signed range is
-9223372036854775808 to 9223372036854775807. The unsigned range is 0
to 18446744073709551615.',<br>
'DECIMAL' => 'A packed "exact" fixed-point number. M is
the total number of digits (the precision) and D is the number of
digits after the decimal point (the scale). The decimal point and
(for negative numbers) the "-" sign are not counted in M. If D is 0,
values have no decimal point or fractional part. The maximum number
of digits (M) for DECIMAL is 65. The maximum number of supported
decimals (D) is 30. If D is omitted, the default is 0. If M is
omitted, the default is 10.',<br>
'FLOAT' => 'A small (single-precision) floating-point
number. Permissible values are -3.402823466E+38 to -1.175494351E-38,
0, and 1.175494351E-38 to 3.402823466E+38. These are the theoretical
limits, based on the IEEE standard. The actual range might be
slightly smaller depending on your hardware or operating system.',<br>
// ....<br>
<br>
I don't think these description should be there, but I don't know
the "right" place. Maybe we should create a database table or a file
to store these information. I've implemented some code to fix this
bug and it's working, maybe I should do a pull request.<br>
<br>
I am pretty new to PhpMyAdmin's codebase.<br>
<br>
Thank you very much and sorry about my english.<br>
</body>
</html>