--- title: "setCharacterStream Method (java.lang.String, java.io.Reader, long) | Microsoft Docs" ms.custom: "" ms.date: "01/19/2017" ms.prod: sql ms.prod_service: connectivity ms.reviewer: "" ms.technology: connectivity ms.topic: conceptual ms.assetid: 54fb2f13-f8d8-47b5-bec1-4a5af3e86a84 author: David-Engel ms.author: v-daenge --- # setCharacterStream Method (java.lang.String, java.io.Reader, long) [!INCLUDE[Driver_JDBC_Download](../../../includes/driver_jdbc_download.md)] Sets the designated parameter to the specified java.io.Reader object, which is the specified number of characters long. ## Syntax ``` public final void setCharacterStream(java.lang.String parameterName java.io.Reader reader, long length) ``` #### Parameters *parameterName* A **String** that contains the parameter name. *reader* A Reader object that contains the Unicode data. *length* A **long** that indicates the number of characters in the stream. ## Exceptions [SQLServerException](../../../connect/jdbc/reference/sqlserverexception-class.md) ## Remarks This setCharacterStream method is specified by the setCharacterStream method in the java.sql.CallableStatement interface. If the length of the stream is different than what is specified in the *length* parameter, the JDBC driver throws an exception when the row is updated or inserted. If the length of the stream is unknown, the *length* parameter may be set to -1 to indicate that the driver should accept the stream regardless of its length. With sqljdbc4.jar, we recommend that you use the JDBC 4.0 method [setCharacterStream Method (java.lang.String, java.io.Reader)](../../../connect/jdbc/reference/setcharacterstream-method-java-lang-string-java-io-reader.md) when the application wants to update the column from a stream whose length is unknown. ## See Also [setCharacterStream Method (SQLServerCallableStatement)](../../../connect/jdbc/reference/setcharacterstream-method-sqlservercallablestatement.md) [SQLServerCallableStatement Members](../../../connect/jdbc/reference/sqlservercallablestatement-members.md)