Re: Maximum field length with PHP 4.1.2/MSSQL v7 ?

"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 ?"