[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-windows
Subject:    RE: [PHP-WIN] Weird PHP Problem
From:       "Matt Kynaston" <Matt.Kynaston () etbroker ! com>
Date:       2002-11-27 13:03:12
[Download RAW message or body]

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:lferro@teladigital.net]
> Sent: 27 November 2002 12:30
> To: php-windows@lists.php.net
> 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

[prev in list] [next in list] [prev in thread] [next in thread]