#36069 [Bgs]: AGAIN - mysql_field_type returns 'unknown' for DECIMAL columns in MySQL 5.0+

ID: 36069 Updated by: georg@php.net Reported By: alcofora at netmake dot com dot br Status: Bogus Bug Type: MySQL related Operating System: Windows PHP Version: 5.1.2 New Comment: If you don't like to compile your php stuff, use the dll's for mysql/mysqli from the MySQL AB web site: http://dev.mysql.com/downloads/connector/php/ Previous Comments: ------------------------------------------------------------------------ [2006-01-19 14:22:22] tony2001@php.net As I've said, PHP must be *compiled* with the version of MySQL where these types are available. These types won't magically appear in php_mysql.dll just because you're using new libmysql.dll. ------------------------------------------------------------------------ [2006-01-19 14:09:45] alcofora at netmake dot com dot br Hi, Now i'm using PHP 5.1.2 and MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 5.0.16 I'm using libmysql.dll that comes from MySQL5. The problem with decimal still happening. ------------------------------------------------------------------------ [2006-01-18 18:20:26] tony2001@php.net No, it shouldn't. And we also do not distribute separate modules for all versions of Oracle, Interbase, Sybase, MSSQL, Postgresql, Ingres, DB2 etc. ------------------------------------------------------------------------ [2006-01-18 18:09:43] alcofora at netmake dot com dot br Hi, I understant that, but i'm using WINDOWS binary package that comes from php.net. I don't compile anything WINDOWS. Shouldn't the binary official version come with the newest MySQL Client API, including support for ALL MySQL? Thanks. ------------------------------------------------------------------------ [2006-01-18 17:35:53] tony2001@php.net PHP must be compiled with MySQL 5 to support field types that appeared first in MySQL 5. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/36069 -- Edit this bug report at http://bugs.php.net/?id=36069&edit=1