Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    34

    Unanswered: Store and display html text in Oracle 9i

    We stored html text as CLOB data type in Oracle 9i, but we got problem to display it in ASP.NET, the html decode did not work as below, html text display as source format:
    "<table><tr><td>This is a test</td></tr></table>"

    string content = Server.HtmlDecode((string)dr["html"]);
    HtmlHolder.Controls.Add(new LiteralControl(content));

    We guess we need to convert CLOB binary format to string, but we can not figure it out how to do it.

  2. #2
    Join Date
    Jan 2004
    Location
    Scottsdale, AZ
    Posts
    106

    Post

    I've never used it, but did you consider Oracle XML DB?

    http://download-west.oracle.com/docs...nt.htm#1047232
    "Take Control!
    Make The Choice!
    Accept The Consequences!
    Deal With The Results! "

  3. #3
    Join Date
    Jun 2004
    Posts
    34
    We try to port microsoft IBuySpy portal solution to Oracle, and it works fine stored as ntext data type in SQL Server, now we convert data from SQL Server to Oracle and stored as CLOB data type.

    The problem is that data fetched from Oracle return in binary format like below:

    "&\0l\0t\0;\0t\0a\0b\0l\0e\0 \0c\0e\0l\0l ..."

    Now our question is that can we convert the format to string in ASP.NET?
    On the other word convert above characters to "<table><tr>..."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •