Bug #68087 [NEW]: ODBC not reading DATE columns correctly

From: keyur Operating system: Linux PHP version: 5.4.33 Package: ODBC related Bug Type: Bug Bug description:ODBC not reading DATE columns correctly Description: ------------ SQL_DATE column data is coming back corrupted when it follows a WVARCHAR column in the SELECT statement. Test script: --------------- We have a test table with 2 columns: COUNTRY (WVARCHAR) and MONTH (DATE) and execute the statement: SELECT country, month FROM table; Expected result: ---------------- Month should be the full date: yyyy-mm-dd Actual result: -------------- Month is corrupted: yyyy-mm<4 bytes of junk> -- Edit bug report at https://bugs.php.net/bug.php?id=68087&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=68087&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=68087&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=68087&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=68087&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=68087&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=68087&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=68087&r=needscript Try newer version: https://bugs.php.net/fix.php?id=68087&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=68087&r=support Expected behavior: https://bugs.php.net/fix.php?id=68087&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=68087&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=68087&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=68087&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=68087&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=68087&r=dst IIS Stability: https://bugs.php.net/fix.php?id=68087&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=68087&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=68087&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=68087&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=68087&r=mysqlcfg