"Frank M. Kromann" wrote:

Many thanks Frank, changing from varchar to text did indeed fix the
On reflection, I do now remember reading about this on another mailing
list, it's a pitty my memory failed me when I needed it the most :-)

> The tool used to build the MSSQL extension for PHP (DB Library from Microsoft) was 
>created for  SQL Server 6.x and not updated with the release of 7.x or 2000.
> In version 6.x the max length of char and varchar columns was 255 bytes, and that is 
>what you are seeing when you try to select data from char, nchar, varchar or nvarchar 
>> columns defined to be longar than 255 bytes. If you use the TEXT type you will not 
>have this limitation.
> - Frank
> > Hi All,
> >
> > I've come across an interesting problem. I'm trying to retrieve some
> > text data (in this case a question up to 400 chars), but each time I
> > perform a select statement I only receive the first 255 chars.
> >
> > What's the go here, is this just another microsoft thing ?

Chris MacKenzie

Windows: "Where do you want to go today ?"
 Mac OS: "Where do you want to be tomorrow ?"
  Linux: "Are you coming or what ?"

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

Reply via email to