Uncommented, and set to the max value (2147483647). No effect.

On Tue, 2002-12-10 at 10:57, [EMAIL PROTECTED] wrote:
Adam.
are these lines uncommented in your php.ini? They are under [MSSQL]

; Valid range 0 - 2147483647. Default = 4096.
;mssql.textlimit = 4096

; Valid range 0 - 2147483647. Default = 4096.
;mssql.textsize = 4096

sorry, i'm not replying to the other email. i deleted it accidentally





Jeffrey N Dyke
To: Adam Voigt <[EMAIL PROTECTED]>
12/10/2002 cc: [EMAIL PROTECTED], "Hutchins, Richard"
10:43 AM <[EMAIL PROTECTED]>
Subject: RE: [PHP-DB] MSSQL Text Length Restriction(Document link:
Jeff Dyke)




this little snippet works for me.

mssql_query("set textsize 65536");

HTH
Jeff



Adam Voigt
<adam@cryptoco To: "Hutchins, Richard" <[EMAIL PROTECTED]>
mm.com> cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MSSQL Text Length Restriction
12/10/2002
10:35 AM






Ok, my question was in reguards to Microsoft SQL (MSSQL), you are
referering to MySQL.


On Tue, 2002-12-10 at 10:21, Hutchins, Richard wrote: Look at the tinyblob
(tinytext), mediumblob (mediumtext), blob (text), longblob
(longtext) column types in the MySQL manual. Storage-wise they don't look
too terribly inefficient. -----Original Message-----
From: Adam Voigt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 10:18 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MSSQL Text Length Restriction


I can't seem to get more then 255 characters to be sent back from a field
in our MSSQL database, unless the fields is a "TEXT" type, which is very
inefficient. Anyone know a fix? (I've already tried modifying the max size
variables in the php.ini under the MSSQL section.)






--
Adam Voigt ([EMAIL PROTECTED])
The Cryptocomm Group
My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc




--
Adam Voigt ([EMAIL PROTECTED])
The Cryptocomm Group
My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc








-- 
Adam Voigt ([EMAIL PROTECTED])
The Cryptocomm Group
My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc

Attachment: signature.asc
Description: This is a digitally signed message part

Reply via email to