A related problem with the query Analyzer and MS SQL server 7.0:
255 character column width is the default value used by the Query Analyzer.
There exists an option in the menu "Query->Current Connection Options"
select this, and then select the tab "Advanced", there you will find the
field "Maximum characters per column", this adjust the, yes you got it, the
maximum output length of each column.
Regards,
/Anders
>-----Original Message-----
>From: Andrian Pervazov
>Sent: Wednesday, April 18, 2001 3:46 PM
>To: Dan Cleveland
>Cc: Josh Seward; Daniel Furse; [EMAIL PROTECTED]
>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.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
