MediaCollection triggers hsql "invalid character value for cast" (code = 3438)

[Former Member]

I want to implement a simple list of medias visible both in the editorArea and in the HMC (really classic implementation)

I created it as the following :

in editorArea_A.xml:

 <property qualifier="ProductMarketing.otherImages" visible="true" editor="multi" >
          ... some parameters ...
 </property>

I chose editor "multi" for convenience, as I'm already using it for other collections

in items.xml:

 <attribute qualifier="otherImages" type="MediaCollection">
         <persistence type="property" />
 </attribute>    

(I also added it to the locale with a common name, no strange chars)

When I try to upload an image to this list (from the editorArea and from the HMC), my image is correctly uploaded and I can find it under correct path in File system, as given by mydb.log:

 INSERT INTO MEDIAS VALUES(3,'2018-04-16 09:53:19.440000','2018-04-16 09:53:25.868000',8796093513810,NULL,8798373609502,'image/png',15111,8798373642270,'hc2/h00/8798373642270.png','...a 64 chars hash','image_3E3BB2B5.png','sqlerrordemo','replicated273654712',NULL,NULL,1,NULL,8796093055030,NULL,NULL,8796093088344,8796093121113,0,0,... 24xNULL...)
 

However, right after the upload, I have this error:

Cound not update item, reason: java.sql.SQLDataException: data exception: invalid character value for cast(error code : 3438)

When I upload it from the HMC, the error is more detailed, but the additional infos weren't that useful. The stacktrace from debug perspective didn't help me either.

I think that I may miss an important point related to Collections, and I know how trivial my question could be but I dug into tons of ressources and have been into a load of problems trying to resolve this issue.

Thank you for your time!

[Former Member]

moved from the yaas space