Re: Re: PHP & MSSQL

personally, i had luck with the statement below, but have sent it to others in the past and they had varying results. but give this a shot at the top of your page that your PHP code is running on. mssql_query("set textsize 65536"); hth Jeff "Adam Presley" <adam@it-storm.co To: php-db@lists.php.net m> cc: m> Subject: [PHP-DB] Re: PHP & MSSQL 08/11/2003 10:26 AM I know what you're going through here. In MS SQL you can define a VARCHAR up to about 8000 characters, but your PHP mssql_query command only returns 255 (0 - 254) characters. I then tried using the TEXT datatype. TEXT datatype in MS SQL allows somewhere around 2 billion characters. However, the PHP mssql_query command only returns 4096 characters every time. This appear to be a limitation of the PHP MSSQL commands. "Shaun Bentley" <shaun.bentley@ntlworld.com> wrote in message news:20030811101834.97025.qmail@pb1.pair.com... > Hi > I am currently trying to use PHP and MSSQL together but I am having a > few problems. > > I can enter data into the Db OK, but when pulling the data back to display > on the page, the string cuts to around 250 chars. The Db field is VarChar > 6000 and I can see the whole data in the field. > > I have tried pulling the data out as object, array & row but always lose the > end. > > Any help please! > > Shaun > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php