[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 signature.asc Description: This is a digitally signed message part
RE: [PHP-DB] MSSQL Text Length Restriction
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
RE: [PHP-DB] MSSQL Text Length Restriction
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 signature.asc Description: This is a digitally signed message part
RE: [PHP-DB] MSSQL Text Length Restriction
this little snippet works for me. mssql_query("set textsize 65536"); HTH Jeff Adam Voigt 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MSSQL Text Length Restriction
Didn't work, thanks anyway. On Tue, 2002-12-10 at 10:43, [EMAIL PROTECTED] wrote: this little snippet works for me. mssql_query("set textsize 65536"); HTH Jeff Adam Voigt 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 signature.asc Description: This is a digitally signed message part
RE: [PHP-DB] MSSQL Text Length Restriction
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 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MSSQL Text Length Restriction
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 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 PRO
RE: [PHP-DB] MSSQL Text Length Restriction
Adam IIRC this is a known problem with the native php SQL Server APIs which were built using the original TDS drivers based on v6.x of SQL Server which did not support NVARCHAR data types... if you can't change the datatype to TEXT then try a cast. Failing that does it work if you use ODBC instead? Rich -Original Message- From: Adam Voigt [mailto:[EMAIL PROTECTED]] Sent: 10 December 2002 15:18 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MSSQL Text Length Restriction
Adam IIRC this is a known problem with the native php SQL Server APIs which were built using the original TDS drivers based on v6.x of SQL Server which did not support NVARCHAR data types... if you can't change the datatype to TEXT then try a cast. Failing that does it work if you use ODBC instead? Rich -Original Message- From: Adam Voigt [mailto:[EMAIL PROTECTED]] Sent: 10 December 2002 16:01 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] MSSQL Text Length Restriction 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php