This discussion is archived
1 Reply Latest reply: Aug 14, 2012 5:26 AM by odie_63 RSS

CLOB to BLOB replacing spaces with Â

Matt.Smith Newbie
Currently Being Moderated
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 Â
    odie_63 Guru
    Currently Being Moderated
    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


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