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


-----Original Message-----
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
> 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/ 
> 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

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to