db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-769) CLOB and BLOB descriptions do not specify the default length
Date Fri, 03 Mar 2006 21:35:41 GMT
    [ 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


Mime
View raw message