Re: Not returning all text

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Ron,

If your field is of type char or varchar the limit is 255 (limited by the
db library from Microsoft). If you are using the text type you can use
these settings in php.ini

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

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

You can set both of these from the script with the ini_set() function
(http://us4.php.net/ini-set).

- Frank

> Quick question,
> 
> I have a field in MS SQL that is returning a very lengthy string of
text.
> When the string is input it is all making it into the database, but when
I
> return it and display the data on screen it is truncating well
> prematurely.  Is there a setting in the ini that limits this?  and if
so
> can I change the valu inline (like set_time_limit(120000)).
> 
> Thanks,
> Ron
> 
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

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


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux