Max characters in datareader/dataset?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • MRW

    Max characters in datareader/dataset?

    Does anybody know anything about a default limit of 249 characters to a
    datareader/dataset field?

    I'm trying to pull off a 200 word record from an Access MEMO field in a
    GridView and the reader and dataset used to get it only displays the
    first 249 characters.

    Any help would greatly be appreciated!

  • Marina Levit [MVP]

    #2
    Re: Max characters in datareader/dataset?

    No, there is no such restriction. Something else is going on that would
    cause characters to be cut off.

    "MRW" <mwinne1@yahoo. comwrote in message
    news:1158170255 .164633.128960@ b28g2000cwb.goo glegroups.com.. .
    Does anybody know anything about a default limit of 249 characters to a
    datareader/dataset field?
    >
    I'm trying to pull off a 200 word record from an Access MEMO field in a
    GridView and the reader and dataset used to get it only displays the
    first 249 characters.
    >
    Any help would greatly be appreciated!
    >

    Comment

    • MRW

      #3
      Re: Max characters in datareader/dataset?

      Mmm... After some more research, I think it's something to do with the
      SQL String being a UNION...

      Thanks for the update!

      Marina Levit [MVP] wrote:
      No, there is no such restriction. Something else is going on that would
      cause characters to be cut off.
      >
      "MRW" <mwinne1@yahoo. comwrote in message
      news:1158170255 .164633.128960@ b28g2000cwb.goo glegroups.com.. .
      Does anybody know anything about a default limit of 249 characters to a
      datareader/dataset field?

      I'm trying to pull off a 200 word record from an Access MEMO field in a
      GridView and the reader and dataset used to get it only displays the
      first 249 characters.

      Any help would greatly be appreciated!

      Comment

      Working...