RE: [PHP-WIN] SQL Server 2000 and PHP 4.3.1

And that is how DBlib works. If you use ODBC or other methods to access the SQL server you can get all the data back from a (var)char column with more than 256 characters in. DBLib is limited to 256 characters and no support for nchar, nvarchar and ntext as these features was not included in SQL Server 6.0. - Frank > It works for me only if I define the field in SQL as a text. If I use a varchar(256+) it only returns the first 255. > > Charles > > -----Original Message----- > From: Svensson, B.A.T. (HKG) [mailto:B.A.T.Svensson@lumc.nl] > Sent: Tuesday, May 13, 2003 1:47 AM > To: 'Frank M. Kromann ' > Cc: 'php-windows@lists.php.net ' > Subject: RE: [PHP-WIN] SQL Server 2000 and PHP 4.3.1 > > > I am not quit sure what you are refering to as a bug? > MS SQL server is able to return any char length if needed. > I am frequently using MS SQL sever to return formated pages with 2000 chars width. > > -----Original Message----- > From: Frank M. Kromann > To: Charles P. Killmer > Cc: php-windows@lists.php.net > Sent: 2003-05-12 23:20 > Subject: Re: [PHP-WIN] SQL Server 2000 and PHP 4.3.1 > > You can call it a bug, but it is caused by limitations in DBLib, provided by Microsoft. This library has not been updated since SQL Server 6.0 ! > > Iøm working on a solution to use FreeTDS on Win32. Until I have a working solution, you can avoid using (var)char columns greater than 256. > > - Frank > > > SQL Server 2000 allows varchar(8000) though trying to read that > > through PHP returns only 255 characters. > > > > Do I have to set some special configuration to get the other 7000+ > > characters? Or is this a bug? > > > > Charles Killmer > > > > > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >