1 2 Previous Next 24 Replies Latest reply: Feb 22, 2013 2:08 AM by Martin1 Go to original post RSS
      • 15. Re: WebDAV encoding problem
        Marco Gralike
        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
          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
            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
              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
                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
                  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
                    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
                      Marco Gralike
                      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
                        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
                          Hi Odie,

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

                          Regards,
                          Martin
                          1 2 Previous Next