1 Reply Latest reply: Dec 11, 2012 10:42 AM by JeromeFr RSS

    Change db2 encoding to utf in String field

      Hi Gurus,

      We need to retrieve a field from db2 and send it to Siebel via Web Service in order to insert that data. We are having trouble with the encoding and we were wondering if there is any function to change encoding from db2 to utf so we can add it to our xml.

      We believe that changing the encoding will insert it propperly in Siebel.

      Thank you very much,

        • 1. Re: Change db2 encoding to utf in String field
          Hi Alvaro,

          What is the technology of your staging area ?
          In Oracle, you have a function to do that kind of change : http://docs.oracle.com/cd/B28359_01/server.111/b28286/functions027.htm .

          If your staging is not Oracle, you can probably find something similar.

          You can apply it to all your string mappings. If you always use that function for string data with these technology, you can also edit your KM and put the function in it.