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

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