You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by fu...@apache.org on 2006/03/14 23:20:42 UTC
svn commit: r385916 - in /db/derby/docs/trunk/src/ref: rrefblob.dita
rrefclob.dita
Author: fuzzylogic
Date: Tue Mar 14 14:20:41 2006
New Revision: 385916
URL: http://svn.apache.org/viewcvs?rev=385916&view=rev
Log:
DERBY-769: Update reference manuals to include default lengths of BLOB/CLOB
Committed for Jeff Levitt <de...@mylevita.com>
Modified:
db/derby/docs/trunk/src/ref/rrefblob.dita
db/derby/docs/trunk/src/ref/rrefclob.dita
Modified: db/derby/docs/trunk/src/ref/rrefblob.dita
URL: http://svn.apache.org/viewcvs/db/derby/docs/trunk/src/ref/rrefblob.dita?rev=385916&r1=385915&r2=385916&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefblob.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefblob.dita Tue Mar 14 14:20:41 2006
@@ -1,4 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "reference.dtd">
<!--
Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
@@ -14,9 +16,6 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-
-<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
<reference id="rrefblob" xml:lang="en-us">
<title>BLOB</title>
<prolog><metadata>
@@ -24,20 +23,22 @@
</metadata></prolog>
<refbody>
<section> <p>A BLOB (binary large object) is a varying-length binary string
-that can be up to 2,147,483,647 characters long. Like other binary
-types, BLOB strings are not associated with a code page. In addition, BLOB
-strings do not hold character data.</p> <p>The length is given in bytes for
-BLOB unless one of the suffixes K, M, or G is given, relating to the multiples
-of 1024, 1024*1024, 1024*1024*1024 respectively. </p> <note>Length is specified
-in bytes for BLOB.</note></section>
-<refsyn><title>Syntax</title> <codeblock><b>
-{ BLOB | BINARY LARGE OBJECT } ( <i>length</i> [{K |M |G }]))
+that can be up to 2,147,483,647 characters long. Like other binary types,
+BLOB strings are not associated with a code page. In addition, BLOB strings
+do not hold character data.</p><p>The length is given in bytes for BLOB unless
+one of the suffixes K, M, or G is given, relating to the multiples of 1024,
+1024*1024, 1024*1024*1024 respectively. </p><note>Length is specified in bytes
+for BLOB.</note></section>
+<refsyn><title>Syntax</title><codeblock><b>
+{ BLOB | BINARY LARGE OBJECT } [ ( <i>length</i> [{K |M |G }] ) ]
</b></codeblock> </refsyn>
-<section><title>Corresponding compile-time Java type</title> <p><i>java.sql.Blob</i></p> </section>
-<section><title>JDBC metadata type (java.sql.Types)</title> <p>BLOB</p> <p>Use
+<section><title>Default</title><p>A BLOB without a specified length is defaulted
+to one megabyte.</p> </section>
+<section><title>Corresponding compile-time Java type</title><p><i>java.sql.Blob</i></p> </section>
+<section><title>JDBC metadata type (java.sql.Types)</title><p>BLOB</p><p>Use
the <i>getBlob</i> method on the <i>java.sql.ResultSet</i> to retrieve a BLOB
handle to the underlying data.</p> </section>
-<section><title>Related information</title> <p>see <xref href="rrefjdbc96386.dita#rrefjdbc96386"></xref></p> </section>
+<section><title>Related information</title><p>see <xref href="rrefjdbc96386.dita#rrefjdbc96386"></xref></p> </section>
<example> <codeblock><ph>create table pictures(name varchar(32) not null primary key, pic blob(16M));
</ph>
--find all logotype pictures
@@ -51,4 +52,3 @@
order by 1,2;</codeblock> </example>
</refbody>
</reference>
-
Modified: db/derby/docs/trunk/src/ref/rrefclob.dita
URL: http://svn.apache.org/viewcvs/db/derby/docs/trunk/src/ref/rrefclob.dita?rev=385916&r1=385915&r2=385916&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefclob.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefclob.dita Tue Mar 14 14:20:41 2006
@@ -1,4 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "reference.dtd">
<!--
Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.
@@ -14,9 +16,6 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-
-<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
<reference id="rrefclob" xml:lang="en-us">
<title>CLOB</title>
<prolog><metadata>
@@ -24,18 +23,19 @@
</metadata></prolog>
<refbody>
<section> <p>A CLOB (character large object) value can be up to 2,147,483,647
-characters long. A CLOB is used to store unicode character-based
-data, such as large documents in any character set.</p> <p>The length is given
-in number characters for both CLOB, unless one of the suffixes K, M, or G
-is given, relating to the multiples of 1024, 1024*1024, 1024*1024*1024 respectively. </p>Length
+characters long. A CLOB is used to store unicode character-based data, such
+as large documents in any character set.</p><p>The length is given in number
+characters for both CLOB, unless one of the suffixes K, M, or G is given,
+relating to the multiples of 1024, 1024*1024, 1024*1024*1024 respectively. </p>Length
is specified in characters (unicode) for CLOB.</section>
-<refsyn><title>Syntax</title> <codeblock><b>{CLOB |CHARACTER LARGE OBJECT}(length [{{K |M |G}]))</b></codeblock> <p>Corresponding
-Compile-Time Java Type</p> <p>java.sql.Clob</p> <p>JDBC Metadata Type (java.sql.Types)</p> <p>CLOB</p> </refsyn>
-<section><title>Corresponding Compile-Time Java Type</title> <p><i>java.sql.Clob</i></p> </section>
-<section><title>JDBC Metadata Type (java.sql.Types)</title> <p>CLOB</p> <p>Use
+<refsyn><title>Syntax</title><codeblock><b>{CLOB |CHARACTER LARGE OBJECT} [ ( length [{K |M |G}] ) ]</b></codeblock> </refsyn>
+<section><title>Default</title><p>A CLOB without a specified length is defaulted
+to one megabyte.</p> </section>
+<section><title>Corresponding Compile-Time Java Type</title><p><i>java.sql.Clob</i></p> </section>
+<section><title>JDBC Metadata Type (java.sql.Types)</title><p>CLOB</p><p>Use
the <i>getClob</i> method on the <i>java.sql.ResultSet</i> to retrieve a CLOB
handle to the underlying data.</p> </section>
-<section><title>Related Information</title> <p>See <xref href="rrefjdbc96386.dita#rrefjdbc96386"></xref>. </p> </section>
+<section><title>Related Information</title><p>See <xref href="rrefjdbc96386.dita#rrefjdbc96386"></xref>. </p> </section>
<example> <codeblock>import java.sql.*;
public class clob
@@ -87,4 +87,3 @@
}</codeblock> </example>
</refbody>
</reference>
-