Hi, DB-Library from Microsoft has not been updated since SQL Server 6.x and Microsoft wants people to move to OLE DB so they have no plans on updating the (outdated) library. DB-Library is an old component fram Sybase.
The only way to solve this is to use ADO through COM to communicate with the SQL Server, but this will not be available from a Linux/Unix box. - Frank > 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
