Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2010
    Posts
    10

    Unanswered: [XML] value attribute encoded

    Hello
    I found strange behaviour. The same string pushed into xml element value and xml attribute value is represented in different way if string contains national characters.

    for example:

    Code:
    select xmlelement(name "test", xmlattributes('Görögország' as field), 'Görögország')
    will produce:

    Code:
    <test field="G&#xF6;r&#xF6;gorsz&#xE1;g">Görögország</test>

    Why?
    Last edited by MaXyM; 06-10-10 at 08:31.

  2. #2
    Join Date
    Apr 2010
    Posts
    16
    I haven't been able to reproduce this issue.
    Following I have tried:
    edb=# select xmlelement(name "test", xmlattributes('Grgorszg' as field), 'Grgorszg');
    xmlelement
    ----------------------------------------
    <test field="Grgorszg">Grgorszg</test>
    (1 row)

    Regards,
    Vibhor Kumar
    (PCP,OCP)
    ITIL V3 Certified\n

  3. #3
    Join Date
    Apr 2010
    Posts
    10
    To see the result you have to use some diacritics (national characters). You can just copy my command and test against your server.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •