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     
                                                                            
                                                                            
                                                                            







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

Reply via email to