Environment: win10 SqlServer2000 php5.5 yii2.0.7
Problem: After executing the stored procedure readAll(), a single line and single field can return up to 4096 characters, while the stored procedure definition is 8000 characters, resulting in incomplete display.
Code:
<code>$sp_sql = "EXEC {$sp_name} "; $sp_command = $this->db->createCommand($sp_sql); $stmt = $sp_command->query(); $rowset = $stmt->readAll(); var_dump($rowset);</code>
Return:
<code>array(1) { [0]=> array(1) { ["json"]=> string(4096) "{"RowCount":"56","Data": </code>
Tried method (no results): It seems that the odbc here is not valid for the PDO method.
<code>php.ini里面配置 odbc.defaultlrl = 4096 </code>
Reference materials (no results):
http://www.cnblogs.com/longhs/p/3628315.html
Environment: win10 SqlServer2000 php5.5 yii2.0.7
Problem: After executing the stored procedure readAll(), a single line and single field can return up to 4096 characters, while the stored procedure definition is 8000 characters, resulting in incomplete display.
Code:
<code>$sp_sql = "EXEC {$sp_name} "; $sp_command = $this->db->createCommand($sp_sql); $stmt = $sp_command->query(); $rowset = $stmt->readAll(); var_dump($rowset);</code>
Return:
<code>array(1) { [0]=> array(1) { ["json"]=> string(4096) "{"RowCount":"56","Data": </code>
Tried method (no results): It seems that the odbc here is not valid for the PDO method.
<code>php.ini里面配置 odbc.defaultlrl = 4096 </code>
Reference materials (no results):
http://www.cnblogs.com/longhs/p/3628315.html