Re: String truncate problem of varchar when interfacing with a MS SQL server

maybe you set it to "BLOB" can support more char. "B.A.T. Svensson" <B.A.T.Svensson@lumc.nl> ???????:001701c26877$326ac450$ce017c0a@3-hkg-02-0028.lumc.nl... > > I don't know how to work around this problem; is it possible that this is a bug, > > or that I have to run a certain command on the MS SQL before I fetch that variable? > > No, its a settings problem for you: default column widths are set to 255 characters. > > > If so, which command would it be? > > It is for 99% dependent on your data communication/exchange protocol, > which one are you using? ODBC? If so, check out these manual page: > > http://www.php.net/manual/en/function.odbc-longreadlen.php > http://www.php.net/manual/en/function.odbc-field-len.php