Hi, 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 Microsoft. 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, bye, Chris Mackenzie wrote: >"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 ?" > -- -------------------------------------- Michael Bretterklieber LCP 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 [EMAIL PROTECTED] homepage: http://www.jawa.at --------- privat ----------- E-mail: [EMAIL PROTECTED] 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
