[jboss-jira] [JBoss JIRA] Commented: (JBPM-702) Use non-nullable binary fields instead of varbinary on Sybase

[Tom Baeyens (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBPM-702?page=comments#action_12340203 ] 
            
Tom Baeyens commented on JBPM-702:
----------------------------------

i believe this is related to the case we examined some time ago, right ?  i tried searching for it in salesforce but couldn't find it.  can you locate it ?

i believe that the solution to this problem was clear: the types in the jbpm schema needed to change from VARBINARY to BINARY NOT NULL.  

so the question in this issues is merely how we will incorporate this into our software.  is that  correct ?

maybe we can add it to the conversion script that we already have in place for JBPM-701

> Use non-nullable binary fields instead of varbinary on Sybase
> -------------------------------------------------------------
>
>                 Key: JBPM-702
>                 URL: http://jira.jboss.com/jira/browse/JBPM-702
>             Project: JBoss jBPM
>          Issue Type: Sub-task
>          Components: Core Engine
>            Reporter: Ryan Campbell
>         Assigned To: Tom Baeyens
>             Fix For:  jBPM 3.1.2
>
>
> Sybase truncates trailing zeros of blobs which prevents blog retrieval.  These fields need to be created as non-nullable binary fields, not varbinary.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira