I ran into the same problem, but the problem I have is that I can't 
switch to TEXT Datatype because MSSQL doesen't support SELECT DISTINCT 
or GROUP BY on them. The Workaround:

SELECT CAST (fieldxyz AS TEXT) FROM tabelle abc

is not useful because we build db-independent apps.

I tried to recompile the MSSQL-Extension with MSSQL-Server 2000 with 
Service Pack 2 without success. I also changed the define DBMAXCHAR in 
the file
Programme/Microsoft SQL Server/80/Tools/DevTools/Include/sqlfront.h to a 
higher value, but this does offcourse not affect precompiled libs from 

At the moment I have no idea how to solve this? :-(

... but in the Query-Analyzer is a setting where you can define the max 
data-length returned by a field on the fly, so there must be some 
settings, or the Query Analyzer doesen't use this db-lib,


Chris Mackenzie wrote:

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

Michael Bretterklieber
JAWA Management Software GmbH
Liebenauer Hauptstr. 200
A-8041 GRAZ
Tel: ++43-(0)316-403274-12
Fax: ++43-(0)316-403274-10
GSM: ++43-(0)676-93 96 698
homepage: http://www.jawa.at
--------- privat -----------
homepage: http://www.inode.at/mbretter
"...the number of UNIX installations has grown to 10, with more expected..."
           - Dennis Ritchie and Ken Thompson, June 1972 

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

Reply via email to