Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

Data from database are displayed as "?????"

Hi there,

I load fields from one table from a database and the data that i get are like this:

Instead of the word "GLYFADA" i get "G??F???".

Are there any options to try and play with the encoding of the incomming data?

Please Help.

Tags (2)
2 Replies
Not applicable

Re: Data from database are displayed as "?????"

If u use ODBC connector u can change encoding inside of connector.

Control Pannel - Administration - ODBC Data Sources

If not u can try to use codepage() or/and applycodepage() functions inside QlikView (read help).

Else use SQL Transact requests with specified codepage to return required.

Not applicable

Re: Data from database are displayed as "?????"

Hi there.

Thank you for your quick response.

Can you give me any examples for any of the solutions you mentioned?