[
http://issues.apache.org/jira/browse/DERBY-769?page=comments#action_12368800 ]
Daniel John Debrunner commented on DERBY-769:
---------------------------------------------
Just noticed that the syntax does not indicate the lengh is optional, and for
CLOB has an extra open brace before the K
and an extra closing paren at the end (as does BLOB). I think this is the
correct syntax
{CLOB |CHARACTER LARGE OBJECT} [ (length [ {K |M |G} ] ) ]
{ BLOB | BINARY LARGE OBJECT } [ ( length [ {K |M |G } ] ) ]
> CLOB and BLOB descriptions do not specify the default length
> ------------------------------------------------------------
>
> Key: DERBY-769
> URL: http://issues.apache.org/jira/browse/DERBY-769
> Project: Derby
> Type: Bug
> Components: Documentation
> Versions: 10.1.1.0
> Reporter: Daniel John Debrunner
> Priority: Trivial
> Attachments: derby769.diff, rrefblob.html, rrefclob.html
>
> BLOB without a length has a default length of 1 mega byte, ie. same as
> BLOB(1M)
> CLOB without a length has a default length of 1 mega characters, ie. same as
> CLOB(1M)
> http://db.apache.org/derby/docs/10.1/ref/rrefblob.html
> http://db.apache.org/derby/docs/10.1/ref/rrefclob.html
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
