Re: is there any limit to how long of a string SqlDataReader.GetString() can return?

I believe the only limitation is the underlying data type in sql. For
example a varchar can only be max 8000 chars. but text could be up to 2
gigs.

"Daniel" <softwareengineer98037@xxxxxxxxx> wrote in message
news:uTdm7M2YGHA.500@xxxxxxxxxxxxxxxxxxxxxxx
is there any limit to how long of a string SqlDataReader.GetString() can
return?




.

Relevant Pages

  • Re: Db2dclgn Indicator variables
    ... It is true that "49-levels" are used by most SQL products for holding ... I'd love to see a COBOL that supports the ANY LENGTH PREFIXED ... clause for a much more natural VARCHAR. ... I'd also love to see some kind of COBOL support for "null" values. ...
    (comp.lang.cobol)
  • Re: how to insert xml into sql 2005
    ... For right now I just know I have to get this into the sql database. ... to XML processing no matter how big the XML document is. ... ,captionnohtml varchar 'CaptionNoHTML' ...
    (microsoft.public.sqlserver.xml)
  • Re: Stored Procedure calling RPGLE
    ... A common problem using the given procedure definition, would be the use of CHAR versus VARCHAR. ... Unless the type is defined by a field or bound in a program, the VARCHAR must be used because the SQL will type the parameter as VARCHAR. ... IBM iSeries Access or another RPG program, it executes fine. ...
    (comp.sys.ibm.as400.misc)
  • Re: Inserting an Email Address fails.
    ... 'Position' VARCHAR NOT NULL, ... "You have an error in your SQL syntax. ... corresponds to your MySQL server version for the right syntax to use ...
    (perl.dbi.users)
  • RE: Using Jet to read excel file returns blank for last cell - som
    ... This is exactly what I did yesterday - make the SQL datatype varchar. ... > post the excel file and your vb6 project files as a zip file and then post ...
    (microsoft.public.excel.programming)