[PHP] Re: varchar size mssql

[Ben Ramsey]

The problem is that I want to stick with standard SQL.  I would assume 
that convert() is a MS SQL Server function, and, thus, not standard 
(will not work in other database formats).

Did what you read mention why the data was being truncated?  Perhaps if 
I knew why, then I could fix it.

Jason Davidson wrote:

I read that the varchar size for ms sql is 8000 limit.
i also read that someone having a problem with it getting truncated
fixed his problem by using convert(text, $value) in the sql statement..
Jason
--
Regards,
 Ben Ramsey
 http://benramsey.com
 http://www.phpcommunity.org/wiki/People/BenRamsey
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php