SelectBlob and UpdateBlob in PowerServer can only handle the value with UTF8 character encoding (EncodingUTF8!).
When UpdateBlob updates a UTF8 value in PowerServer, or when UpdateBlob updates a UTF16LE value in PowerBuilder, SelectBlob in PowerServer can correctly display the value using the UTF8 or ANSI encoding while SelectBlob in PowerBuilder can correctly display the value using the default UTF16LE encoding.
You can write scripts below to minimize the impact of this discrepancy:
if ispowerserverapp () = true then
Lblob = Blob("Any Text", EncodingUTF8!)
Updateblob caseresfile set filestring = :lblob where filename = :as_filename;
SELECTBLOB filestring into :lblob from caseresfile where filename = :as_filename;
ls_return = String(lblob, encodingutf8!)
else
Lblob = Blob("Any Text")
Updateblob caseresfile set filestring = :lblob where filename = :as_filename;
SELECTBLOB filestring into :lblob from caseresfile where filename = :as_filename;
ls_return = String(lblob)
end if
