Blob Data

mhughes60

<p>Has anyone had success using expressions with native JavaScript functions to manipulate blob data?  It will work on standard data fields, but does not seem to work with blob data fields.  I was testing with the 'toLowerCase' and 'replace' functions.</p>

Clement Wong

<p>You won't be able to use <em>toLowerCase </em>and <em>replace </em>functions for Strings on the Blob data field.  The native data type for "Blob" is represented as a byte array.  You can see this by creating a computed column (type String) and using the expression:</p>
<pre class="_prettyXprint">
            row["TheBlobColumnName"].getClass().getName();</pre>
<p>which will return "[B", or if you use:</p>
<pre class="_prettyXprint">
            row["TheBlobColumnName"].getClass().getSimpleName();
</pre>
<p>whch will return "byte[]".</p>
<p> </p>
<p>What is your use case, and maybe we can figure a solution for you?</p>