Re: SQL Server - 255 field size limit in PHP ?

Thanks Flint... and thanks also to Louis Gree. I changed the type in SQL Server from varchar to text and it sorted out the problem. Cheers Des "Flint Doungchak" <flint@modulusgroup.com> wrote in message news:92BC9A90F2D7FD41AD97761F7E522C28371104@nx-enterprise.modulusgroup.com.. . Dessie, The deal is that the default microsoft libraries that are used as a part of the module (the mssql module) doesn't support varchar beyond 255 chars. Although SQL Server does, since the library doesn't, you're kinda screwed. You could use ADO. I know that the person who works on the SQL server module is working on a fix, but that fix entails not use the microsoft sql server library. I think the play is to use Free DTS at some point. Don't recall. That could be a while. That's the deal. Sorry. -Flint -----Original Message----- From: DessieD [mailto:des_doyle@yahoo.com] Sent: Tuesday, July 01, 2003 2:55 AM To: php-windows@lists.php.net Subject: [PHP-WIN] SQL Server - 255 field size limit in PHP ? Hi Im new to PHP so may be an obvious workaround to this. Not sure if it could be a bug in PHP.. I have a SQLServer table that contains a large nvarchar field (size: 2000). My php code to retireve and display this field is something like (dont have code to hand right now): $quote = mssql_fetch_array($query); echo $quote[0]; The problem is that only the first 255 characters are getting returned by PHP !? The mssql_fetch_array function creates the returned array so its not something I can manually size etc. Anyone seen this before, or offer any comments ?? Thanks D -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php