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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] . 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:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 2:55 AM To: [EMAIL PROTECTED] 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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
