Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
New-Qlik
Creator II
Creator II

Sweden/Danish special characters

Hi Everyone,

I have a column which have data with Sweden/Danish special characters like Å,å,Ä,ä,Ö,ö Å,å,Æ,æ,Ø,ø

when I am trying to load it and  it is getting replace with ?

example malmö is coming as malm?

How do I get original world in qliksense as from database its coming fine.

Thanks
Avneet

3 Replies
dplr-rn
Partner - Master III
Partner - Master III

Which is the database? the driver might make a difference. see discussion below

https://community.qlik.com/message/98802

New-Qlik
Creator II
Creator II
Author

I am using Amazon redshift.

marcus_sommer

Beside the capabilities of the driver (in general and/or in regard to apply certain charsets for the queries) it might be related to collation, see: Search - But what shall you find?‌ Collation could since QV 12 be defined with a variable in the load-script: CollationLocale‌.

- Marcus