Relevant information Oracle Database 11g Enterprise Edition Release 11.1.0.7. Should I change some settings? (Relevant settings shown below).
result (mandatory): This is what is returned if the search value mentioned previously matches the expression value. search (mandatory): This is the value to compare against the expression.
Should I use another function? (These were recommended somewhere on the Internet). The parameters of the Oracle DECODE function are: expression (mandatory): This is the value to compare. How can I have all entities properly decoded? However, is this Oracle itself doing this, or the client (I tried in both SQL+ and Toad)? When I plug utl_i18n.unescape_reference into the query used by the Java program, it works for entities like ± (±), but again, not for the Chinese characters. I realise that in the second row, the inverted question marks seem to indicate that the entities were converted, but can't be displayed properly. These aren't decoded properly, as can be seen in the example above. I have no easy access to the Java code, but I do have control over the query used by the program.Īn example of Chinese characters that I use for testing is 激光, which Google Translate tells me means 'laser' and which I receive encoded as 激 光. #Oracle select xml decode pdf
My actual problem involves Chinese characters, processed by a Java program to create PDF reports. The results I get are: METHOD HEARTS AMP_ENT AMP_DEC AMP_HEX CHINESE_LASERĭbms_nvert ♥ & & & 激 光 I've tried dbms_nvert and utl_i18n.unescape_reference but the results are less than satisfactory.
I'm trying to decode html containing html entities.
0 kommentar(er)
