|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #56510 Describe table gives unexpected result mysql and type enum
Submitted: 2005-08-24 09:49 UTC Modified: 2005-09-10 15:27 UTC
From: amue63 at t-online dot de Assigned: wez (profile)
Status: Closed Package: PDO (PECL)
PHP Version: 5.0.3 OS: Linux
Private report: No CVE-ID: None
 [2005-08-24 09:49 UTC] amue63 at t-online dot de
I try to get meta information on a table in a mysql db.
the table contains a column named "Phase" that is of type enum. 
For columns of type "enum" the query below always returns the first 40 characters describing the columntype correctly however all following characters are random.

Reproduce code:
$select = $db->query('DESCRIBE Study Phase',PDO_FETCH_ASSOC);
foreach ($select as $row) { print_r($row); }

Expected result:
 Array ( [Field] => Phase [Type] => enum('please_select','I','II','IIa','IIb','III','IV') [Null] => Ynf [Key] => [Default] => [Extra] => ) 

Actual result:
 Array ( [Field] => Phase [Type] => enum('please_select','I','II','IIa','IIb9{some random output} 
[Null] => Ynf [Key] => [Default] => [Extra] => )


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2005-08-24 20:22 UTC]
Please try the latest PHP 5.0.x stable snapshot from, I believe that this issue has already been fixed.
 [2005-08-25 10:02 UTC] amue63 at t-online dot de
I tried 5.1.0_rc1 and got the same result. 
(I could not compile the lastest stable 5.0.x snapshot 
because the ebuild on Gentoo Linux does not work) 
PHP 5.0.4 on Windows gives the correct result, however.
 [2005-09-10 15:27 UTC]
Unable to repeat with tip of the 5.1 branch; assuming that it's been fixed.
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Apr 23 04:01:29 2024 UTC