Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Special Characters in Qlikview

Hi,


I have a problem with special chars like "ñ" or "Á" that appear with "?".
The problem exists when I download data into qvd.
Data is downloaded into qvds, from Oracle database.In Oracle database, data is correct.

I don´t want to remove or skip special chars.

There Exists some setting to set the encoding to UTF-8? or I have to use some pl/sql function to bring the correct data into qvd.

Thanks in advance.

Greetings.


Rodrigo E.

1 Reply
jaspsing
Contributor II
Contributor II

Hello ,

I know it's so much old post, but searching through the post for some problem your post give an idea and here is the solution.

you can use ApplyCodePage on that field and apply UTF-8 as 10000.

Ex:

ApplyCodePage(Field,10000) as NewField

All your hidden or special character will start appearing.

Thanks