Hi, On 17 March 2011 09:54, Alex Osborn <[email protected]> wrote: > Hi, > > Have been tasked with tidying a few things on a legacy app we have > inherited - it is using Pear DB_Dataobject with a MSSQL 2008 database. > > One bug to fix was that a certain 'text' type column appears to > truncate data after a certain point when reading / displaying. As far > as I can tell this limit isn't on the database - if a longer string is > saved, this is correctly saved when manually checking the database, > but the data is cut when loading the object from the database. > if you are using the mssql/TDS driver, then you have to (from memory)
a) extend the limit size for blobs: ; Valid range 0 - 2147483647. Default = 4096. mssql.textlimit = 2147483647 ; Valid range 0 - 2147483647. Default = 4096. mssql.textsize = 2147483647 (for some reason I can't find these settings in php.net, but one of our servers is set up like this) b) cast the column to TEXT HTH. -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
