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
