Stay organized with collections Save and categorize content based on your preferences.
JdbcClobA JDBC Clob
. For documentation of this class, see java.sql.Clob
.
free()
void
For documentation of this method, see java.sql.Clob#truncate(long)
. getAppsScriptBlob()
Blob
Gets the content of this JdbcClob as an Apps Script blob. getAs(contentType)
Blob
Return the data inside this object as a blob converted to the specified content type. getSubString(position, length)
String
For documentation of this method, see java.sql.Clob#getSubString(long, int)
. length()
Integer
For documentation of this method, see java.sql.Clob#length()
. position(search, start)
Integer
For documentation of this method, see java.sql.Clob#position(Clob, long)
. position(search, start)
Integer
For documentation of this method, see java.sql.Clob#position(String, long)
. setString(position, blobSource)
Integer
Convenience method for writing a JdbcClob
to a clob. setString(position, blobSource, offset, len)
Integer
Convenience method for writing a JdbcClob
to a clob. setString(position, value)
Integer
For documentation of this method, see java.sql.Clob#setString(long, String)
. setString(position, value, offset, len)
Integer
For documentation of this method, see java.sql.Clob#setString(long, String, int, int)
. truncate(length)
void
For documentation of this method, see java.sql.Clob#truncate(long)
. Detailed documentation getAppsScriptBlob()
Gets the content of this JdbcClob as an Apps Script blob.
ReturnBlob
— A Blob
that can be used directly by other Apps Script APIs.
getAs(contentType)
Return the data inside this object as a blob converted to the specified content type. This method adds the appropriate extension to the filename—for example, "myfile.pdf". However, it assumes that the part of the filename that follows the last period (if any) is an existing extension that should be replaced. Consequently, "ShoppingList.12.25.2014" becomes "ShoppingList.12.25.pdf".
To view the daily quotas for conversions, see Quotas for Google Services. Newly created Google Workspace domains might be temporarily subject to stricter quotas.
Parameters Name Type DescriptioncontentType
String
The MIME type to convert to. For most blobs, 'application/pdf'
is the only valid option. For images in BMP, GIF, JPEG, or PNG format, any of 'image/bmp'
, 'image/gif'
, 'image/jpeg'
, or 'image/png'
are also valid. For a Google Docs document, 'text/markdown'
is also valid. Return
Blob
— The data as a blob.
getSubString(position, length)
For documentation of this method, see java.sql.Clob#getSubString(long, int)
.
position
Integer
The index of the first character of the substring to extract. The first character is at index 1. length
Integer
The number of consecutive characters to copy (must be 0 or greater). Return
String
— The retrieved substring.
length()
For documentation of this method, see java.sql.Clob#length()
.
Integer
— The length (in characters) of this clob.
position(search, start)
For documentation of this method, see java.sql.Clob#position(Clob, long)
.
search
JdbcClob
The clob object to search for. start
Integer
The position at which to begin searching; the first position is 1. Return
Integer
— The position at which the specifed clob appears, or -1 if it is not present.
position(search, start)
For documentation of this method, see java.sql.Clob#position(String, long)
.
search
String
The substring to search for. start
Integer
The position at which to begin searching; the first position is 1. Return
Integer
— The position at which the specifed substring appears, or -1 if it is not present.
setString(position, blobSource)
Convenience method for writing a JdbcClob
to a clob.
position
Integer
The position at which writing to the clob starts; the first position is 1. blobSource
BlobSource
The blob source to write. Return
Integer
— The number of characters written.
setString(position, blobSource, offset, len)
Convenience method for writing a JdbcClob
to a clob.
position
Integer
The position at which writing to the clob starts; the first position is 1. blobSource
BlobSource
The blob source to write. offset
Integer
The offset into the provided string where reading characters to write starts. len
Integer
The number of characters to write. Return
Integer
— The number of characters written.
setString(position, value)
For documentation of this method, see java.sql.Clob#setString(long, String)
.
position
Integer
The position at which writing to the clob starts; the first position is 1. value
String
The string to write. Return
Integer
— The number of characters written.
setString(position, value, offset, len)
For documentation of this method, see java.sql.Clob#setString(long, String, int, int)
.
position
Integer
The position at which writing to the clob starts; the first position is 1. value
String
The string to write. offset
Integer
The offset into the provided string where reading characters to write starts. len
Integer
The number of characters to write. Return
Integer
— The number of characters written.
truncate(length)
For documentation of this method, see java.sql.Clob#truncate(long)
.
length
Integer
The size (in bytes) of this clob after truncation.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-02 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-02 UTC."],[[["JdbcClob is a JDBC wrapper for the `java.sql.Clob` object, providing methods for interacting with Character Large OBjects (CLOBs) within Apps Script."],["It allows you to retrieve the CLOB's content as an Apps Script Blob, access substrings, and determine its length."],["You can also modify the CLOB by writing strings or BlobSources to specific positions within it."],["Several methods, like `free()` and `truncate()`, are directly based on their `java.sql.Clob` counterparts, referring to their documentation for details."],["`getAs()` facilitates data conversion into various content types, enabling integration with other Apps Script functionalities."]]],["JdbcClob, a JDBC `Clob`, allows manipulation of large character data. Key actions include: retrieving content as an Apps Script blob or a specified content type, extracting substrings by position and length, and determining the total character length. It also allows finding the position of a substring or another clob, and writing to the clob with strings or blob sources at specified positions, offsets, and lengths. Finally, it allows the user to truncate the clob by specifying the length.\n"]]
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4