Question: I'm maintaining a web application written in PHP that connects to a MSSQL database.  

The original developer used <http://adodb.sourceforge.net/> as his database library.

The problem is, when reading data using the `GetAll` method, all the strings are truncated to 255 chars. 

Has anyone a solution to my problem?

edit: The column I am having a problem with is a `varchar(800)`

Answer: 
What exactly are you able to change?

I stumbled across this article, which may help: [ADODB Varchar Limit Problem](http://www.sitepoint.com/forums/showthread.php?t=506868)

What it seems to suggest you try is:

1. Change your column type from `varchar` to `text`
2. In the select statement, stipulate a `CAST` for the column:

i.e.:

```
select CAST(MyColumn as text) as MyColumn  

```

The post cites the following two articles, which back up the above

<http://php.oregonstate.edu/manual/en/ref.mssql.php#47527>

<http://php.oregonstate.edu/manual/en/ref.mssql.php#71602>

Hope this helps
I don't have problems using ADODB in PHP to query MSSQL. I write queries in the following way:

```
<?php
// assuming $db is properly configured and connected ADODB database object
$rs = $db->Execute("SELECT ...");
while (!$rs->EOF) {
    print $rs->fields['fieldname'];
    // further processing of row
    $rs->MoveNext(); // move to the next row
}

```