Norwegian Letters - SQL

[_Kristina_]

Hi,

In the last couple of weeks I've run into problems with Norwegian letters in the SQL query (oracle).

The code is not working when I have Norwegian letters in it (ÆØÅ). This worked earlier, and is now causing a lot of trouble for me. 

Please fix!

Best Regards

Kristina

[_Kristina_]

Hi,

In the last couple of weeks I've run into problems with Norwegian letters in the SQL query (oracle).

The code is not working when I have Norwegian letters in it (ÆØÅ). This worked earlier, and is now causing a lot of trouble for me. 

Please fix!

Best Regards

Kristina

[v-qiuyu-msft]

Hi @_Kristina_ ,

Which query do you use to get data? Do you use Import or DirectQuery connection mode? 

Please share detail steps so we can test it on our side. 

Best Regards,
Qiuyun Yu 

[_Kristina_]

Hi @v-qiuyu-msft !

I use import and I'm connecting to an Oracle database. Some of my where statements contain these letters, which means I have to import the whole dataset now and filter it in the query editor instead. This is giving me a huge dataset to import.

Please ask if there are any more details needed.

Best regards,

Kristina