#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Posts
    63
    Rep Power
    15
    Hello all. I have a textarea that is saving to a mssql text (very large) field. The insert, update is working fine. However, when php reads the data using mssql_result function, I'm getting limited to 4096 characters read by php. I know that there are at least 6000 characters and I can see them using microsoft's query analyzer. This is not a magic quotes, single quote, quote, html entity or anthing like that. PHP will not read more than 4096 from my microsoft sql text field. Any ideas how I can get php to read more?

    Thanks in advance.

    Ulysses J Ludwig
    213.948.8278
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    43
    Rep Power
    15
    Yeah, this can be a pain.
    MS SQL by default does not read more than that page of data, you have to run a the SQL command:

    SET TEXTSIZE <bytes>

    -- to retrieve more data. Run this command and execute it, then run your SQL query. I do this: SET TEXTSIZE 1024000 so that I can get up a meg worth of text out each shot.


    ------------------
    PHP, Perl, SQL Programming at http://www.mentalobjects.com
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Posts
    63
    Rep Power
    15
    Right on!

    UJL

Similar Threads

  1. Replies: 3
    Last Post: February 17th, 2004, 10:08 AM
  2. help with tables and wordwrapping
    By junkedBrian613 in forum PHP Development
    Replies: 2
    Last Post: February 15th, 2004, 05:42 PM
  3. Wan to select partial text in a text field
    By raghava66 in forum HTML Programming
    Replies: 2
    Last Post: February 12th, 2004, 02:11 AM
  4. how to upload text file into blob field
    By misoz in forum MySQL Help
    Replies: 8
    Last Post: February 5th, 2004, 02:48 AM
  5. Simple find and replace word search for a text file with php?
    By rabid lemming in forum PHP Development
    Replies: 4
    Last Post: February 1st, 2004, 09:37 PM

IMN logo majestic logo threadwatch logo seochat tools logo