Bug #65738 [Com]: Column metadata for datetimeoffset is incorrect
| From: | chriskl@php.net | Date: | Mon, 23 Sep 2013 02:56:11 +0000 |
| Subject: | Bug #65738 [Com]: Column metadata for datetimeoffset is incorrect | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-181747@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=65738&edit=1
ID: 65738
Comment by: chriskl@php.net
Reported by: chriskl@php.net
Summary: Column metadata for datetimeoffset is incorrect
Status: Open
Type: Bug
Package: MSSQL related
Operating System: Debian 7.1
PHP Version: 5.5.4
Block user comment: N
Private report: N
New Comment:
Actually, unfortunately on a real char field, it also returns "char" and also type
47 :( So I'm not sure how to distinguish these.
Previous Comments:
------------------------------------------------------------------------
[2013-09-23 02:53:43] chriskl@php.net
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 this bug report at https://bugs.php.net/bug.php?id=65738&edit=1