Edit report at http://bugs.php.net/bug.php?id=44278&edit=1
ID: 44278 Comment by: tidelipop at gmail dot com Reported by: ethan dot nelson at ltd dot org Summary: nvarchar(max) mangled Status: Open Type: Bug Package: PDO related Operating System: win2k3 PHP Version: 5.2.7 New Comment: Well, when will this bug be fixed!? I need to use this now! /Andreas Previous Comments: ------------------------------------------------------------------------ [2009-05-26 18:56:03] ethan dot nelson at ltd dot org The following article is important even though it has to do with encryption. The bug report exposes what PDO is using to execute queries, sp_prepexec. The comment from an MS moderator is that it is an unsupported feature. There may be another choice for use by PDO than prepexec. http://social.msdn.microsoft.com/Forums/en- US/sqlsecurity/thread/e7e54926-27d5-4c84-99af-a5335c72ef3c ------------------------------------------------------------------------ [2009-05-26 06:52:44] ian at mutexlabs dot com I can confirm this bug on Windows 2003, PHP 5.2.7, 5.2.9 and the 5.2.10-dev release linked in this bug. I'm actually using the odbc_* functions, not PDO, but the behaviour is the same. I worked around the problem by rebuilding the database using nvarchar(255) instead of nvarchar(max) types - it was safer than modifying the PHP app. I saw similar (corruption) behaviour on varchar and char types, though I didn't investigate closely. text columns are OK, but unsuitable for my application. ------------------------------------------------------------------------ [2009-05-19 22:51:45] ethan dot nelson at ltd dot org No difference in behavior from what I can see. Can you reproduce the bug on your end? My screen reports the following using my reproduce code (with a few lines from the phpinfo command()): SELECT CAST('asdfasdfasdf' AS nvarchar) AS good, CAST('asdfasdfasdf' AS nvarchar(max)) AS garbled Array ( [0] => Array ( [good] => asdfasdfasdf [garbled] => �í[(í[��� ) ) PHP Logo PHP Version 5.2.10-dev System Windows NT LTD-PWWW2 5.2 build 3790 Build Date May 19 2009 11:39:28 Configure Command cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--with-snapshot-template=d:\php-sdk\bin\\..\snap_5_2\vc6\x86\template" "--with-php-build=d:\php-sdk\bin\\..\snap_5_2\vc6\x86\php_build" "--with-pdo-oci=D:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8=D:\php-sdk\oracle\instantclient10\sdk,shared" Server API ISAPI ------------------------------------------------------------------------ [2009-05-03 01:00:10] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2009-04-25 14:54:59] [email protected] Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://windows.php.net/snapshots/ ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/bug.php?id=44278 -- Edit this bug report at http://bugs.php.net/bug.php?id=44278&edit=1
