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 column? Thanks a lot Kelvin -----Original Message----- From: Roedel, Mark [mailto:MarkRoedel@letu.edu] Sent: Monday, March 31, 2003 2:27 PM To: Poon, Kelvin (Infomart); php-db@lists.php.net Subject: RE: MSSQL/PHP problem > -----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: 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
