Text issue in SQL box in Analysis

Question

Hi All,

any idea what could be wrong? If I go to the Advanced tab in the analysis and click New Analysis button under the SQL Issued box new pop up window appears with SQL query. But the special characters are replaced with such codes &#39 or &quot and so on.

If I click OK error appears.

Please can anybody advice?

Best regards

Petr

Boček Petr · Answer

Same browser. I did what you asked for Christian but no success. If I paste it to notepad it looks same as the source.

I also crested analysis without any special charactet but the result is still the same. So in 12 version I see &quot instead of " and saving is not accepting the code with &quot...

Petr

[Deleted User] · Answer

"in 11.9g" with the same browser as well?

Maybe just copy+paste out what the buffer captures when you Ctrl+C thigns in 11 and 12 respectively and put it into a pure text file to see when and where the covnersion happens

Boček Petr · Answer

Ok in terms of english alphabet, yes I do :-) Ok I will check to have some analysis excluding any special characters and let's see.

Nevertheless this was not a problem in 11.9g :-(