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