Hi, now I rewrote my PHP-DB-Module using COM and ADO (OLEDB), it works well, the 255 Bytes limitation doesen't exist with this method, but uff it takes a lot of memory, after openening the db-connection, the php-process increases his memory usage with about 4 MB, this seems to be a problem of COM (big overhead). But on the oder hand, if microsoft propagates this as the only method to access MS SQL, then its a problem of those customers who uses microsoft products.
bye, Michael Bretterklieber wrote: > 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 ?" >> > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
