Are you using mssql_* functions? They limit varchar and nvarchar to 256 characters. For workarounds take a look through the user comments in the manual, or use odbc_*
Matt > -----Original Message----- > From: Luis Ferro [mailto:[EMAIL PROTECTED]] > Sent: 27 November 2002 12:30 > To: [EMAIL PROTECTED] > Subject: Re: [PHP-WIN] Weird PHP Problem > > > SQL Server is notorious for is fair amount of bugs... With that in > prespective i must ask: > > a) Are you reading the fields in EXACTLY the same order as > they appear > in the filed list in the SQL Server Enterprise Manager? [SQL > Server will > return damaged results if one tries to read strings in a > diferent order] > > b) Will the same happens if the field is of type Text? > > Cheers... > Luis Ferro > > P.S.- Hope that provides some "hints" on how to solve the > problem... i'm > not an expert in SQL Server... > > > Becky Gruebmeyer wrote: > > >Ok...Using newest version of PHP on an NT IIS machine with a SQL 2000 > >database. Here is the issue: > > > >I have a nvarchar field with a size of 4000. > >I submit a text string from a form to this field. > >It will display on submit using echo nl2br($variable) and it > will display > >fine. > >When I look in the database, it has all the information > stored correctly. > >When I pull it back out of the database, it cuts it off and > only displays > >the first part of the string. > > > >Anyone have any ideas why? > > > > > > > > > > > > > --- > [This E-mail scanned for viruses by Declude Virus] > > > -- > 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
