PDO MSSQL query result field limited to 255 chars

Win XP Sp2
IIS
MSSQL Server Express 2005
PHP 5.2.3

I am using PDO with the MSSQL database but I have a problem which I think must be a setting somewhere that I have missed. The FULL_DESC field in the database is a VARCHAR(5000) and appears fine when I query it throught the Server Management Studio Express. When I copy it from the table, it is the correct length (which is 3000 chars).

I want to query it and display it on my web page but it is being truncated at 255 chars.

Before I show the code I am using, I just want to say that I have tried setting mssql.textsize = 4096 & mssql.textlimit = 4096 in the php.ini file and restarting the IIS server but no difference.

I cannot help feeling a fool and feeling I have missed something obvious. Any ideas please?

obviously the connection to the db has been established before this code.

Code:

    try {
       foreach ($dbh->query("SELECT FULL_DESC FROM PROJECT WHERE PROJECT_ID = '2'") as $row) {
          echo "<BR>".strlen($row['FULL_DESC'])."-".$row['FULL_DESC'];
       }
       $dbh = null;
    } catch (PDOException $e) {
       print "Error!: " . $e->getMessage() . "<br/>";
       die();
    }
    exit;

[Join us @ facebook]

I am afraid you wont find a solution here as most of us are dedicated to open source technologies (eg. mysql)

The only thing I can think of is that your db class is truncating the data

I dont think it is a MSSQL problem because, as I said, the query analyser shows the full string in the database. I think it is more a PHP setting that I have forgotten or overlooked, or it might be a problem with the PDO code. However, if it is a problem with the PDO code then someone else must have found it by now.

Since PDO is an standard loadable extension to PHP. I thought someone on this PHP forum might be able to spot what I have missed.

[Free WordPress Themes]

I remember the last Zend conference that one of the speakers told us that PDO has some problems.

try PHP functions for MSsql

[Join us @ facebook]

First this is an experimental extension. Then looking at your code, looks a little wrong. Try to replace it with this :

Code:

       $res = $dbh->prepare("SELECT FULL_DESC FROM PROJECT WHERE PROJECT_ID = '2'");
       $res->execute();
       while ( $row = $res->fetch() ) {
          var_dump($row);

Hope that works

[Free WordPress Themes]

First this is an experimental extension. Then looking at your code, looks a little wrong. Try to replace it with this :

yeah some experimental extension which is part for the zend certification

I have tried that other code, and the same thing appears. Still truncated at 255 chars.

When I do a SELECT LEN(FULL_DESC) AS LNGTH.... and then echo $row['LNGTH'] it reports the correct length.

It is  looking as if I will have to use the mssql statements but I was trying not to use anything too specific to MSSQL. However, the SQL statements are slightly different in some areas to mySQL so I would have to change them if I started to use mySQL anyway. It means going through all my programs and changing the code which I was hoping not to do. How does anyone else develop webapps that can use either mySQL or MSSQL - it must be full of 'if' statements!

[Free WordPress Themes]

there are several (better) database abstraction classes (check pear)

[Join us @ facebook]

The different is mostly to the LIMIT statement. I think there is a db class that do the changes for you. I am not sure but the DB PEAR package has this ability.

[Guest]

[37.734]

Yahoo crawler, adsense, Baidu Spider, Msnbot