Re: Re: PHP & MSSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I believe this is only applicable to fields of type "text".  It may have
no effect on varchar(>255) fields.  The purpose of this statement is to
limit the amount of memory allocated by the driver for text data. If it is
not specified, the driver will try to allocate 2GB of memory.  The
extension sets this value to 4096 by default.

-- bob

On Mon, 11 Aug 2003 jeffrey_n_Dyke@Keane.com wrote:

>
> 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:
>                                                Subject:   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
> 20030811101834.97025.qmail@pb1.pair.com">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
>
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux