1 Reply Latest reply: Aug 14, 2012 7:26 AM by odie_63 RSS

    CLOB to BLOB replacing spaces with Â

      I have a CLOB that we are converting to a BLOB using DBMS_LOB.CONVERTTOBLOB and then serving it up as a file using WPG_DOCLOAD.DOWNLOAD_FILE. When you open the file, it is replacing the spaces with a Â.

      Any thoughts?
        • 1. Re: CLOB to BLOB replacing spaces with Â
          Most likely, the spaces in the original CLOB were not regular spaces (0x20) but rather non-breaking spaces (0xA0).

          What's the target encoding used to convert to BLOB? I suppose UTF-8?

          UTF-8 encodes non-breaking spaces as 0xC2A0, where 0xC2 is specifically the codepoint for "Â". So I think the tool you're using doesn't support UTF-8, or doesn't recognize the file as being properly encoded.

          Edited by: odie_63 on 14 août 2012 14:26