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: Append to SQL Server
    ... IF it is varChar then perhaps you can use the Trim or RTrim function on the memo field in the query. ... It is possible that the Access memo field does contain trailing spaces depending on how the data got into the memo field. ... It works fine except if the field has 10 characters, 245 blank spaces are put at the end in SQL Server. ...
    (microsoft.public.access.queries)
  • 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)