"Frank M. Kromann" wrote: Many thanks Frank, changing from varchar to text did indeed fix the problem. 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 ? -- Rgds, 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