Felipe Vidal
Active Member
I created the following DB function, which I expect will retrieve the text from table F00165.
(Usage in F00165):
The problem is that it retrieves the text in the following BLOB format:
This is an issue because when I convert this into CLOB, those zeroes are converted into "invisible" characters:
I read that this is related to the Character Set F00165 is configured with, but how can I then translate F00165 into a usable string without needing to modify such string after applying the CLOB conversion to it? Today trying to use the resulting text generates completion errors.
(Usage in F00165):
The problem is that it retrieves the text in the following BLOB format:
This is an issue because when I convert this into CLOB, those zeroes are converted into "invisible" characters:
I read that this is related to the Character Set F00165 is configured with, but how can I then translate F00165 into a usable string without needing to modify such string after applying the CLOB conversion to it? Today trying to use the resulting text generates completion errors.