How to convert UTF8 special characters to the actual character

Question

Question

Nina Nif4 · Mar 29

#DTL #Caché #InterSystems IRIS for Health

We are receiving the report in text format and it has special characters like ', - like that in the text. Source system is using the UTF8 encoding format hence the text is showing as ' � ' . Is there a way to convert the utf8 to actual character in the DTL.

Product version: IRIS 2022.1

Discussion (1)1

Log in or sign up to continue

score 0 · Answer 1 · 2025-03-29T11:14:16-04:00

To convert UTF-8 encoded text with special characters to actual characters in Data Transformation Language (DTL), you can use the $ZCONVERT function. This function can convert encoded data to the desired character set. For example, you can use $ZCONVERT(data, "I", "UTF8") to decode UTF-8 encoded data to its actual characters [1].

Additionally, ensure that the Default Char Encoding setting is correctly configured to handle UTF-8 encoding. This setting can be found in the business service or operation settings, and it should be set to "UTF-8" to ensure proper handling of UTF-8 encoded messages [2][3].