wondering if any of you have encountered a problem where you need to use special characters in your load qvs script. im pivoting a table and it results in a field name with french characters
just the act of pivoting itself does not cause any problem, however theres a business rule i need to perform on one the fields and i need to do some calculation but the resulting field name looks like this: [Taux de réponse],
But the issue might be already happens before - means the replacement might be caused from the data-base / driver / connection. Often there are similar possible adjustments within these tools.
If it are just one or two fields you may to consider to reverse the char-replacement with a mapping-logic, like shown here:
I think maybe you are saying that the problem you have is in an external script file, that gets included in the loadscript when reload is performed?
If so, it sounds like you could solve your issue by changing the locale of the qvs text file. There are tools to do such things, for example the open source software Notepad++ for Windows. Just open the script file in nbotepad++ and convert the encoding in the "Encoding" menu. You will not see any differences on screen, but save the file and try reloading your app again. I'd say it's likely that UTF-8 is what you need, but that your script file is stored in ANSI. (I could be wring, you'll have to experiment.)
