From: chriskl Operating system: Debian 7.1 PHP version: 5.5.4 Package: MSSQL related Bug Type: Bug Bug description:Column metadata for datetimeoffset is incorrect
Description: ------------ When using getColumnMeta() on pdo_dblib, on a column of type 'datetimeoffset(0)', the returned structure looks like this: array(10) { ["max_length"] => int(104) ["precision"] => int(0) ["scale"] => int(0) ["column_source"] => string(7) "updated" ["native_type"] => string(4) "char" ["native_type_id"] => int(47) ["native_usertype_id"] => int(0) ["name"] => string(7) "updated" ["len"] => int(104) ["pdo_type"] => int(2) } Note that it believes that the native_type is char, when it should be 'datetimeoffset'. Expected result: ---------------- I expect to see 'datetimeoffset' as the native_type. Actual result: -------------- You get 'char' - which is incorrect. -- Edit bug report at https://bugs.php.net/bug.php?id=65738&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=65738&r=trysnapshot54 Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=65738&r=trysnapshot53 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=65738&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=65738&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=65738&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=65738&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=65738&r=needscript Try newer version: https://bugs.php.net/fix.php?id=65738&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=65738&r=support Expected behavior: https://bugs.php.net/fix.php?id=65738&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=65738&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=65738&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=65738&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=65738&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=65738&r=dst IIS Stability: https://bugs.php.net/fix.php?id=65738&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=65738&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=65738&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=65738&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=65738&r=mysqlcfg