varchar truncated

Results 1 to 3 of 3

Thread: varchar truncated

  1. #1
    Venson Guest

    Default varchar truncated

    I have seen many people ask about this problem I am having with no solution. Please Help!!. I am using SQL7.0 with a varchar field of 1000 characters. In my asp page my recordset only returns the first 255 characters of the field. In fact the field properties in the recordset show it as 255 characters? What am I doing wrong. I want the entire 1000 characters. Please Help!!

  2. #2
    Sathiya Guest

    Default RE: varchar truncated

    I posted the Question so many times no reply if you get any reply or solution please forward to I tried in microsoft site also no clear answer is available.

  3. #3
    Venson Guest

    Default RE: varchar truncated

    I solved the problem by using the datatype &#039text&#039 rather than char or varchar.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts