RE: [PHP-DB] MSSQL/PHP problem
| From: | Roedel, Mark | Date: | Mon, 31 Mar 2003 19:27:13 +0000 |
| Subject: | RE: [PHP-DB] MSSQL/PHP problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-26754@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Poon, Kelvin (Infomart) [mailto:kpoon@infomart.ca]
> Sent: Monday, March 31, 2003 9:13 AM
> To: 'php-db@lists.php.net'
> Subject: [PHP-DB] MSSQL/PHP problem
>
>
> [snip]
>
> WHen I retrieve this data from php to display on my webpage I
> get this:
>
> Globe and Mail data are retrieved and processed for CustomSearch.
> On the R30, the crontab entry:
> 0 4 * * 1-6 /usr1/applic/ntgm/ntgm_get.pl
> will run the Perl script at 4 a.m. everyday to retrieve the
> data from Globe
> and Mail. It will look for the fi
>
> [snip]
>
> P.S. I have set the limit of the mssql table to have 8000
> character, so it should exceed the limit, but I just don't know
> why it takes only 6 lines of the total 11 lines of what I had in
> the mssql table.
That looks suspiciously close to 255 characters, which I believe is the
maximum size of a char() or varchar() column. If this column is either
of those types, you might consider changing it to 'text'.
---
Mark Roedel | "The most overlooked advantage to owning a
Systems Programmer | computer is that if they foul up there's no
LeTourneau University | law against whacking them around a little."
Longview, Texas USA | -- Owen Porterfield