SelectBlob and UpdateBlob have different results for non-binary fields

The SelectBlob and UpdateBlob functions have different results on the Web from using PowerBuilder, when some non-binary fields are manipulated.

Cause: In some conditions, PowerBuilder automatically removes the spaces before and after the non-binary characters when using SelectBlob and UpdateBlob. However, such operation does not occur to the Web, which leads to different results.

Solution: Appeon recommends you to directly use Select and Update functions to manipulate Blob type fields.