Yeah it worked, thank you very much. I just have one more question.
How much space does the data takes up if I set it to text. Because in
VarChar (which I had before) will change it's size depending how long the
chars is, will changing it to text cause the data to take up a large amount
of space even though the actual text is small?
Second question, I notice when I switch it to text, the length becomes "16"
and I can not change it. So how much text can the column contain then? Or
what is the limit or maximum number of words/letters I can fit into this
Thanks a lot
From: Roedel, Mark [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 2:27 PM
To: Poon, Kelvin (Infomart); [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MSSQL/PHP problem
> -----Original Message-----
> From: Poon, Kelvin (Infomart) [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2003 9:13 AM
> To: '[EMAIL PROTECTED]'
> Subject: [PHP-DB] MSSQL/PHP problem
> 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
> 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
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php