php-windows Digest 17 Aug 2001 10:58:32 -0000 Issue 707
Topics (messages 8914 through 8917):
Re: Retrieving "text" > 4K SQL Server 7.0
8914 by: Elman Cheng
8915 by: Elman Cheng
Re: [PHP] Re: [PHP-WIN] Installation failed ! Please Help!
8916 by: Phil Driscoll
Image Functions
8917 by: Augusto Cesar Castoldi
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
if you use the PHP MSSQL driver,
find a line in php.ini :
mssql.textlimit
= 4096
mssql.textsize
= 4096
and change there are value to you wanted.
elman
Al wrote:
> Setup: PHP 4 and Apache on NT 4; SQL Server 7.0 on NT 4, Unified ODBC
> using SQL Server ODBC driver.
>
> How does one go about getting "text" data out of SQL Server 7.0 using
> PHP's Unified ODBC drivers? This is "text" data... not varchar()!
>
> I can PUT as much data as I want into a "text" column in a table, but
> I can only GET 4096 bytes in a SELECT.
>
> Reading the SQL 7.0 docs, it says 4K is the default amount of data
> that's allowed in a SELECT statement. However, the same docs say that
> when using ODBC, the driver sets it to return the max allowed for the
> machine (~2GB).
>
> I can whip up a Delphi app to use the same ODBC DSN and pull all the
> "text" data out of the column, but I just can't get it to work using
> PHP. I realize there's lots of hidden stuff in Delphi's BDE, so I know
> that's not a valid comparison.
>
> I've also tried using the PHP MSSQL drivers and I get the same
> results, so I'm sure there's something I'm missing on the SQL Server
> 7.0 end.
>
> Help?!?!
>
> -Al
>
if you use the PHP MSSQL driver,
find a line in php.ini :
mssql.textlimit
= 4096
mssql.textsize
= 4096
and change there are value to you wanted.
elman
Al wrote:
> Setup: PHP 4 and Apache on NT 4; SQL Server 7.0 on NT 4, Unified ODBC
> using SQL Server ODBC driver.
>
> How does one go about getting "text" data out of SQL Server 7.0 using
> PHP's Unified ODBC drivers? This is "text" data... not varchar()!
>
> I can PUT as much data as I want into a "text" column in a table, but
> I can only GET 4096 bytes in a SELECT.
>
> Reading the SQL 7.0 docs, it says 4K is the default amount of data
> that's allowed in a SELECT statement. However, the same docs say that
> when using ODBC, the driver sets it to return the max allowed for the
> machine (~2GB).
>
> I can whip up a Delphi app to use the same ODBC DSN and pull all the
> "text" data out of the column, but I just can't get it to work using
> PHP. I realize there's lots of hidden stuff in Delphi's BDE, so I know
> that's not a valid comparison.
>
> I've also tried using the PHP MSSQL drivers and I get the same
> results, so I'm sure there's something I'm missing on the SQL Server
> 7.0 end.
>
> Help?!?!
>
> -Al
>
On Thursday 16 August 2001 7:35 pm, Elias Santiago wrote:
> I believe that IIS passes the script name to php.exe with the first %s. I
> think IIS replaces the first %s with the script name. From the second
> article, I suppose that if the %s is changed to %S, the name passed to
> php.exe would be UPPERCASE. Can anyone verify this?
I can't verify that, but I can verify that I've had php running without any
trouble at all ever on about a dozen NT4 boxes without %s %s anywhere in site
without any problems at all :)
Maybe the default behaviour of IIS (since it is the sensible behaviour) is to
pass the script name to the exe it calls.
Cheers
--
Phil Driscoll
Hi.
i'm using the last version of GD (supports JPEG and PNG) on Solaris 8 unix,
but I need to use this functions on Windows.
How can I do that?
regards,
Augusto
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
