RE: [PHP-WIN] Problems with TEXT fields in MSSQL

Hi Hugo, Depending on what version of PHP you are using and what version of the MSSQL module you are using, you can edit the following lines in the php.ini file to retrieve longer text fields. ; Valid range 0 - 2147483647. Default = 4096. ;mssql.textlimit = 4096 ; Valid range 0 - 2147483647. Default = 4096. ;mssql.textsize = 4096 Frank has made these available in his module for quite some time, so it should work with the version you are running. Take care. -Flint -----Original Message----- From: Hugo Alexandre Almeida Soares Dias [mailto:anikin@ip.pt] Sent: Friday, April 06, 2001 10:21 AM To: php-windows@lists.php.net Subject: [PHP-WIN] Problems with TEXT fields in MSSQL Hi I'm having some problems while using text fields in MSSQL. I update them normally with the UPDATE command, but when i do the SELECT in PHP it only returns me the top 4096 bytes (4KB). Then i did the same thing in the SQL Query Analizer (SQL Enterprise) and the same select returns me just fine. Does anyone knows how i can solve this problem? If so, please include hugo@mni.pt in the reply. Thank you, Hugo Dias Web-programmer MNI-Médicos na Internet www.mni.pt www.saudenainternet.pt www.listamedica.com -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net For additional commands, e-mail: php-windows-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net