setstring-method-long-java-lang-string-int-int.md

title	setString Method (long, java.lang.String, int, int) | Microsoft Docs
ms.custom
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	connectivity
ms.reviewer
ms.technology	connectivity
ms.topic	conceptual
apiname	SQLServerClob.setString (long, java.lang.String, int, int)
apilocation	sqljdbc.jar
apitype	Assembly
ms.assetid	9fb59b09-e825-46a6-ba5d-85d4a8dc143a
author	David-Engel
ms.author	v-daenge

setString Method (long, java.lang.String, int, int)

[!INCLUDEDriver_JDBC_Download]

Writes the given string to the CLOB starting at the given position, based on the given offset and length.

Syntax

  
public int setString(long pos,  
                     java.lang.String str,  
                     int offset,  
                     int len)  

Parameters

pos

The position at which to start writing to the CLOB.

str

The string to be written to the CLOB.

offset

The offset within the string to start reading the characters from.

len

The number of characters to be written.

Return Value

The number of characters written.

Exceptions

java.sql.SQLException

Remarks

This setString method is specified by the setString method in the java.sql.Clob interface.

Character data is overwritten starting at the specified position and can overwrite the initial length of the CLOB. Specifying a position+1 value will append the string. Specifying a position+2 or greater (or zero or less) value will cause a position error to be thrown.

See Also

setString Method (SQLServerClob)
SQLServerClob Methods
SQLServerClob Members
SQLServerClob Class