String Conversion in Qlik Sense

[JayDashtii-911]

Hey there,

I'm using the below function in SQL

UTL_I18N.ROW_TO_CHAR(FIELD_NAME, 'AL16UTF16')

Is there a built-in function to do the same on QVD instead of SQL?

[settu_periasamy]

what is the expected result ?

[JayDashtii-911]

There is a field in our database which is encoded by IT DEPARTMENT, and I have to use this function to display the string in qlik sense.

I’m running the SQL query and store it into a QVD, is there a way to do the same on QVD fields instead of SQL?

[settu_periasamy]

can you give any example, how the values are encoded and stored into QVD while running the SQL Query ?

[Bill_Britt]

You need to the conversion before you store it in a QVD.   It slows down the read speed  if you are doing conversion when you are loading  data from the QVD.

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/QVD_files.htm

If you are worried about security you can always setup QVD encryption.

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Server/Content/QV_Server/QlikView-Server/QVS...