# NClob Added in[API level 9](https://developer.android.com/guide/topics/manifest/uses-sdk-element#ApiLevels) Summary:[Inherited Methods](https://developer.android.com/reference/java/sql/NClob#inhmethods) # NClob ` public interface NClob ` ` implements `[Clob](https://developer.android.com/reference/java/sql/Clob)` ` |----------------| | java.sql.NClob |
*** ** * ** *** The mapping in the Java^TM^programming language for the SQL`NCLOB`type. An SQL`NCLOB`is a built-in type that stores a Character Large Object using the National Character Set as a column value in a row of a database table. The`NClob`interface extends the`Clob`interface which provides provides methods for getting the length of an SQL`NCLOB`value, for materializing a`NCLOB`value on the client, and for searching for a substring or`NCLOB`object within a`NCLOB`value. A`NClob`object, just like a`Clob`object, is valid for the duration of the transaction in which it was created. Methods in the interfaces[ResultSet](https://developer.android.com/reference/java/sql/ResultSet),[CallableStatement](https://developer.android.com/reference/java/sql/CallableStatement), and[PreparedStatement](https://developer.android.com/reference/java/sql/PreparedStatement), such as`getNClob`and`setNClob`allow a programmer to access an SQL`NCLOB`value. In addition, this interface has methods for updating a`NCLOB`value. All methods on the`NClob`interface must be fully implemented if the JDBC driver supports the data type. ## Summary | ### Inherited methods | |-----------------------|---| | From interface` `[java.sql.Clob](https://developer.android.com/reference/java/sql/Clob)` ` |------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | ` abstract void` | ` `[free](https://developer.android.com/reference/java/sql/Clob#free())`() ` This method frees the`Clob`object and releases the resources the resources that it holds. | | ` abstract `[InputStream](https://developer.android.com/reference/java/io/InputStream) | ` `[getAsciiStream](https://developer.android.com/reference/java/sql/Clob#getAsciiStream())`() ` Retrieves the`CLOB`value designated by this`Clob`object as an ascii stream. | | ` abstract `[Reader](https://developer.android.com/reference/java/io/Reader) | ` `[getCharacterStream](https://developer.android.com/reference/java/sql/Clob#getCharacterStream())`() ` Retrieves the`CLOB`value designated by this`Clob`object as a`java.io.Reader`object (or as a stream of characters). | | ` abstract `[Reader](https://developer.android.com/reference/java/io/Reader) | ` `[getCharacterStream](https://developer.android.com/reference/java/sql/Clob#getCharacterStream(long,%20long))`(long pos, long length) ` Returns a`Reader`object that contains a partial`Clob`value, starting with the character specified by pos, which is length characters in length. | | ` abstract `[String](https://developer.android.com/reference/java/lang/String) | ` `[getSubString](https://developer.android.com/reference/java/sql/Clob#getSubString(long,%20int))`(long pos, int length) ` Retrieves a copy of the specified substring in the`CLOB`value designated by this`Clob`object. | | ` abstract long` | ` `[length](https://developer.android.com/reference/java/sql/Clob#length())`() ` Retrieves the number of characters in the`CLOB`value designated by this`Clob`object. | | ` abstract long` | ` `[position](https://developer.android.com/reference/java/sql/Clob#position(java.lang.String,%20long))`(`[String](https://developer.android.com/reference/java/lang/String)` searchstr, long start) ` Retrieves the character position at which the specified substring`searchstr`appears in the SQL`CLOB`value represented by this`Clob`object. | | ` abstract long` | ` `[position](https://developer.android.com/reference/java/sql/Clob#position(java.sql.Clob,%20long))`(`[Clob](https://developer.android.com/reference/java/sql/Clob)` searchstr, long start) ` Retrieves the character position at which the specified`Clob`object`searchstr`appears in this`Clob`object. | | ` abstract `[OutputStream](https://developer.android.com/reference/java/io/OutputStream) | ` `[setAsciiStream](https://developer.android.com/reference/java/sql/Clob#setAsciiStream(long))`(long pos) ` Retrieves a stream to be used to write Ascii characters to the`CLOB`value that this`Clob`object represents, starting at position`pos`. | | ` abstract `[Writer](https://developer.android.com/reference/java/io/Writer) | ` `[setCharacterStream](https://developer.android.com/reference/java/sql/Clob#setCharacterStream(long))`(long pos) ` Retrieves a stream to be used to write a stream of Unicode characters to the`CLOB`value that this`Clob`object represents, at position`pos`. | | ` abstract int` | ` `[setString](https://developer.android.com/reference/java/sql/Clob#setString(long,%20java.lang.String,%20int,%20int))`(long pos, `[String](https://developer.android.com/reference/java/lang/String)` str, int offset, int len) ` Writes`len`characters of`str`, starting at character`offset`, to the`CLOB`value that this`Clob`represents. | | ` abstract int` | ` `[setString](https://developer.android.com/reference/java/sql/Clob#setString(long,%20java.lang.String))`(long pos, `[String](https://developer.android.com/reference/java/lang/String)` str) ` Writes the given Java`String`to the`CLOB`value that this`Clob`object designates at the position`pos`. | | ` abstract void` | ` `[truncate](https://developer.android.com/reference/java/sql/Clob#truncate(long))`(long len) ` Truncates the`CLOB`value that this`Clob`designates to have a length of`len`characters. | ||