#19385 [NEW]: mysql_field_type

From: vlada@activemedia.co.yu Operating system: Windows 2000 PHP version: 4.2.3 PHP Bug Type: MySQL related Bug description: mysql_field_type I'm using MySQL V3.23.51-nt. When used "mysql_field_type" function I found wrong reported types -- or differentone than with "SHOW FIELDS FROM". Here are only some examples: ------------------------------------------------------ mysql_field_type | SHOW FIELDS FROM ------------------------------------------------------ string | varchar(150) ------------------------------------------------------ blob | text ------------------------------------------------------ int | int(11) ------------------------------------------------------ int | tinyint(4) ------------------------------------------------------ real | float ------------------------------------------------------ year | year(4) ------------------------------------------------------ I hope it would help you to find out where is a problem. It seems that mysql_field_type has poor description of the filed types and many similar types it reports the same -- Edit bug report at http://bugs.php.net/?id=19385&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=19385&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=19385&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=19385&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=19385&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=19385&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=19385&r=support Expected behavior: http://bugs.php.net/fix.php?id=19385&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=19385&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=19385&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=19385&r=globals