Web file wizard does not accept Unicode characters

[francescopuppin]

Hi,

if I put this string in the Web file wizard

http://maps.google.com/maps/geo?q=Krakow&output=xml&oe=utf8&sensor=false&key=XXYYZZ

it will give me a nice and clean output.

But if I put this string, the wizard tells me "invalid character" and fails, because of the ó character.

http://maps.google.com/maps/geo?q=Kraków&output=xml&oe=utf8&sensor=false&key=XXY

But, funny thing: if you click on the socond link from here, google does actually accept it and resolve it! So, it is a problem of the wizard.

I would gladly replace the ó with o, but I have a loop with thousands of cities from the world, with too many characters to replace (óo,íi,łl,źz,żz,ýy,áa,ęe,îi,ěe,ée, etc..)

Can anyone tell me how to configure the wizard to accept Unicode characters, or any other way to solve the problem?

Thanks

F.

[Gysbert_Wassenaar]

I had IE8 which showed the same error when I opened your second url. Then I upgraded to IE9 and the error is gone in both IE9 itself and in Qlikview. So, try upgrading to IE9 if you can.

It would be very nice if Qlikview allowed us to choose which browser (engine) to use, but it seems we're stuck with microsofts no-standards-supported-here browser..

edit:

Ah, I see what happened. I copied the url instead of the text of the url. When I copied the url it was properly encoded:

http://maps.google.com/maps/geo?q=Krak%C3%B3w&output=xml&oe=utf8&sensor=false

As far as I know the standard for url's does not allow non-ascii characters in urls. See here also.

So, try encoding the url properly if it isn't already.

[francescopuppin]

Hi Gysbert,

the browser does not give me any error. As I wrote above, if you click on the link with the ó character, google resolves it with perfectly.

The problem is in Qlikview: the wizard of Qlikview does not accept Unicode characters, and it gives an error message even before sending the request to the browser. Any idea how to solve this?

Thanks

F.

[francescopuppin]

Hi,

but where do I find the proper encoding?

I mean, how do I know that ó corresponds to %C3%B3?

I have 4200 locations to search on Google, and each of them potentially contains one or more forbidden characters... Is there a mapping table somewhere?

And I repeat, again... despite the fact that the ó character is forbidden for the URL, the URL works fine!

If you copy this string and paste it into your browser, it works OK!

So, the question is: if it's OK as a URL for the brwser, why it is not ok for the Qlikview wizard?

http://maps.google.com/maps/geo?q=Kraków&output=xml&oe=utf8&sensor=false&key=XXY