db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5505) BLOB and CLOB Reference Manual topics could use some fixes
Date Mon, 21 Nov 2011 22:51:46 GMT

    [ https://issues.apache.org/jira/browse/DERBY-5505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13154698#comment-13154698
] 

Knut Anders Hatlen commented on DERBY-5505:
-------------------------------------------

I'm a bit curious about the truncation you're seeing when using binary strings. Do you have
an example to share?

The limit on binary string literals is documented here: http://db.apache.org/derby/docs/dev/ref/rrefstringlimits.html.
It's 16336 hexadecimal characters, which means that the literals are limited to ~8KB. But
the limit is still not small enough to explain why your files in the range 2.5KB to 5KB would
be truncated. And even so, the parser is supposed to throw an exception rather than truncating
the value when it encounters too long strings.
                
> BLOB and CLOB Reference Manual topics could use some fixes
> ----------------------------------------------------------
>
>                 Key: DERBY-5505
>                 URL: https://issues.apache.org/jira/browse/DERBY-5505
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 10.8.2.2
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>            Priority: Minor
>         Attachments: blobex.java, blobex.java, clobex.java, clobex.java
>
>
> The Reference Manual documentation on BLOBs and CLOBs has some gaps that I would like
to fill as a result of my efforts to insert a BLOB into a table column. This should affect
the following topics:
> CAST function (rrefsqlj33562.dita)
> CLOB data type (rrefclob.dita)
> BLOB data type (rrefblob.dita)
> A comment will provide further details.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message