RE: [PHP-WIN] MSSQL varchar fields truncation revisited

I had the same problem with a cold fusion page a while ago. It turned out that it was nothing to do with cold fusion but actually because I didn't have the latest version of the MDAC components installed onto my cold fusion server. There was a bug in previous versions which meant only the first 255 characters of a vchar field were returned from a query. This could be your problem if you are working on windows (and especially if your database is MS SQL 7)... hth, Kelvin. -----Original Message----- From: Andrian Pervazov [mailto:apervazov@aspen-marketing.com] Sent: 18 April 2001 14:46 To: Dan Cleveland Cc: Josh Seward; Daniel Furse; php-windows@lists.php.net Subject: [PHP-WIN] MSSQL varchar fields truncation revisited I'm still using 3.0.16 and when you have to display a varchar field in a MSSQL table everything over 255 characters gets truncated (this affects only selects, not inserts). I know that a workaround would be to transform the fieldtype from varchar to text, but this isn't very practical in the particular case. So, does anybody know if the problem still exists in later versions of PHP or has been fixed? Other suggestions and workarounds will be appreciated as well. Andrian