This discussion is archived
1 2 Previous Next 24 Replies Latest reply: Feb 22, 2013 12:08 AM by Martin1 Go to original post RSS
  • 15. Re: WebDAV encoding problem
    MarcoGralike Oracle ACE Director
    Currently Being Moderated
    Client site effects on encoding. If not already read, here now a direct link to the XML DB FAQ about encoding: Conversion UTF-8 -> WINDOWS-1250
  • 16. Re: WebDAV encoding problem
    Martin1 Newbie
    Currently Being Moderated
    Hi Marco,

    i tried the FAQ and it works but not when i insert my XML file :-(

    Regards,
    Martin

    Edited by: Martin1 on Feb 20, 2013 2:13 PM
  • 17. Re: WebDAV encoding problem
    Martin1 Newbie
    Currently Being Moderated
    Hi Odie,

    i have still this problem unresolved. Do you have an idea?

    These are the steps i did the last test:
    1. C:\TEMP>set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
    2. Start SQL*Plus
    3. dbms_xmlschema.registerSchema
    4. insert into xmltable (source: WebDAV alternatively: DB directory)
    5. Query
    SELECT pe.name, pe.bes_kennz
    FROM fp_epass_pass_antraege
    , XMLTABLE('/PassAntrag'
    PASSING object_value
    COLUMNS person XMLTYPE PATH '/PassAntrag/Person') paan
    , XMLTABLE('/'
    PASSING paan.person
    COLUMNS name VARCHAR2(512) PATH 'Name'
    , bes_kennz VARCHAR2(200) PATH 'BesKennz') pe;

    The query result has mutilate characters when it should show i.e german umlaut (öäü).

    Regards,
    Martin
  • 18. Re: WebDAV encoding problem
    Martin1 Newbie
    Currently Being Moderated
    Hi Odie,

    the code conversion problem is solved :-)

    I determined that the XML file (encoding="UTF-8") copied into the WebDAV directory is correctly converted to "ISO-8859-15" during the copy process. But when i edit afterwards the XML file (located in WebDAV) and do then an insert into the XMLTYPE table several characters ar mutilated when i query the XMLTYPE table.
    My mistake :-(

    Thanks again for your comprehensive help.

    Best Regards,
    Martin
  • 19. Re: WebDAV encoding problem
    odie_63 Guru
    Currently Being Moderated
    Martin,

    Thanks for the feedback.

    Just a little follow up...

    You're currently storing the same data twice, as a repository resource and again in the XMLType table.
    Is it by design?
  • 20. Re: WebDAV encoding problem
    Martin1 Newbie
    Currently Being Moderated
    Hi Odie,

    thanks for the conceptual question.

    We get the XML file by mail (MS Outlook). Then the user stores it in the WebDAV directory. Afterwards he can process the data via an Oracle Forms application.
    Wolud you recommend another approach?

    Regards,
    Martin
  • 21. Re: WebDAV encoding problem
    odie_63 Guru
    Currently Being Moderated
    Martin1 wrote:
    Wolud you recommend another approach?
    Well, it depends (as always).

    It depends on what is being done in Forms. Is there additional controls done between the time the file is stored via WebDAV and the time it's inserted in the final table?

    If the user just pushes a button to ultimately load the resource in the XMLType table, then this can be done automatically when the file is dropped in the repository. That's what I refered to earlier as "defaultTable mechanism".
  • 22. Re: WebDAV encoding problem
    MarcoGralike Oracle ACE Director
    Currently Being Moderated
    Besides the by Odie mentioned defaultTable / shredding mechanism, you also could control it by making use of the "*schemaLocation-mappings*" configuration in xdbconfig.xml (cant find a direct link but have a look at last bits of the page): http://docs.oracle.com/cd/B28359_01/appdev.111/b28369/appaman.htm#i641205

    Combine this with the XDB Repository Event possibilities and you should be able to control a lot regarding, who, where, etc - automatically...(via mime type, connection, privileges, etc)

    Intro into XDB Repository Events
    http://www.liberidu.com/blog/2011/11/21/howto-xdb-repository-events-an-introduction/
    http://odieweblog.wordpress.com/2012/01/28/xml-db-events-reading-an-open-office-xml-document-xlsx/
    http://www.slideshare.net/MGralike/ukoug-2011-drag-drop-and-other-stuff-using-your-database-as-a-file-server

    Edited by: Marco Gralike on Feb 21, 2013 6:24 PM
  • 23. Re: WebDAV encoding problem
    Martin1 Newbie
    Currently Being Moderated
    Hi Marco,

    thanks for this interesting infos.
    We consider the implementation after we have done the basic xdb tasks.

    Regards,
    Martin
  • 24. Re: WebDAV encoding problem
    Martin1 Newbie
    Currently Being Moderated
    Hi Odie,

    thanks for your message.
    We consider the implementation after we have done the basic xdb tasks.

    Regards,
    Martin
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points