RE: [PHP-DB] MSSQL Text Length Restriction
| From: | Adam Voigt | Date: | Tue, 10 Dec 2002 16:00:44 +0000 |
| Subject: | RE: [PHP-DB] MSSQL Text Length Restriction | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-24013@lists.php.net to get a copy of this message | ||
Uncommented, and set to the max value (2147483647). No effect.
On Tue, 2002-12-10 at 10:57, Jeffrey_N_Dyke@Keane.com 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
<adam@cryptocomm.com>
12/10/2002 cc:
php-db@lists.php.net, "Hutchins, Richard"
10:43 AM
<Richard.Hutchins@GetingeCastle.com>
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"
<Richard.Hutchins@GetingeCastle.com>
mm.com> cc:
php-db@lists.php.net
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:adam@cryptocomm.com]
Sent: Tuesday, December 10, 2002 10:18 AM
To: php-db@lists.php.net
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 (adam@cryptocomm.com)
The Cryptocomm Group
My GPG Key:
http://64.238.252.49:8080/adam_at_cryptocomm.asc
--
Adam Voigt (adam@cryptocomm.com)
The Cryptocomm Group
My GPG Key:
http://64.238.252.49:8080/adam_at_cryptocomm.asc
--
Adam Voigt (adam@cryptocomm.com)
The Cryptocomm Group
My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc