RE: [PHP-WIN] Truncating data

2004-07-28 Thread Robert Twitty
You just ran into a limitation of PHP's mssql extension on Windows. This extension was built with DB-Library, which is obsolete and does not support the new or extended SQL Server 7.0/2000 data types. DB-Library assumes all varchar fields have a max size of 255, which was the case for SQL Server

RE: [PHP-WIN] Truncating data

2004-07-28 Thread Bowden, Zeb
Instead of: SELECT varchar_field FROM table Try: SELECT convert(text,varchar_field) FROM table There might be a more efficient way but this has always worked for me... -zeb -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 28,