Bug #51356 [NEW]: using COM to call MSSQL Stored Procedure

From: Operating system: WINDOWS PHP version: 5.2.13 Package: COM related Bug Type: Bug Bug description:using COM to call MSSQL Stored Procedure Description: ------------ I wrote a Active Dll to call mssql stored procedure using ADO, something like below: Option Explicit Private db As New ADODB.Connection Private adocomm As New ADODB.Command Public Function ExecSP(sql As String) As ADODB.Recordset Set db = New ADODB.Connection db.ConnectionString = CONNECT_STRING db.CursorLocation = adUseClient db.ConnectionTimeout = 30 db.Open Set adocomm.ActiveConnection = db adocomm.CommandType = adCmdStoredProc adocomm.CommandText = "p_Common_Pagination" adocomm.Parameters(1) = sql adocomm.Parameters(2) = 1 adocomm.Parameters(3) = 20 Set ExecSP = adocomm.Execute End Function And Tested OK using VB code, there are some chinese characters: Option Explicit Private rs As New ADODB.Recordset Private ESPTest As New espNew.espc Private sql as String Private Sub Command1_Click() sql = "select * from t_User where FUserID>1000 and FName like '%中国人%' order by FUserID" Set rs = ESPTest.ExecSP(sql) End Sub Below is the Sql Profiler's output: exec p_Common_Pagination N'select * from t_User where FUserID>1000 and FName like ''%中国人%'' order by FUserID', 1, 20 But if I use php to call this DLL: <?php $sql = "select * from t_User where FUserID>1000 and FName like '%中国人%' order by FUserID"; $b= new COM("esp.espc"); $list=$b->ExecSP($sql); ?> The output of the SQL Profiler is : exec p_Common_Pagination N'select * from t_User where FUserID>1000 and FName like ''%中国人%'' order by FUserID The second and the third parameters are missing. I have tesed for a long time, and I'm sure the code I wroted are all right. What's the matter ? Test script: --------------- like above Expected result: ---------------- Fix the bug. -- Edit bug report at http://bugs.php.net/bug.php?id=51356&edit=1 -- Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=51356&r=trysnapshot52 Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=51356&r=trysnapshot53 Try a snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=51356&r=trysnapshot60 Fixed in SVN: http://bugs.php.net/fix.php?id=51356&r=fixed Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=51356&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=51356&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=51356&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=51356&r=needscript Try newer version: http://bugs.php.net/fix.php?id=51356&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=51356&r=support Expected behavior: http://bugs.php.net/fix.php?id=51356&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=51356&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=51356&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=51356&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=51356&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=51356&r=dst IIS Stability: http://bugs.php.net/fix.php?id=51356&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=51356&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=51356&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=51356&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=51356&r=mysqlcfg