We're using iw_include in TPL, specifically the iw_sql tags to read from a Oralce9i database and output a flat html file. Our problem is that some of our unicode data is being translated to two question mark characters ("??"). The original dcr is in the default utf-8 encoding, therefore, the HTML pages can render Chinese characters read from DCRs correctly but not the Chinese characters read from Oracle (the content in Oracle was inserted by DD which is encoded in UTF-8)Does anyone have similar experience? Thanks for help.
you are getting two "??" because of the fact that UTF-8 stores the data in the format e.g."<C2><A0>" hence browsers misread it as two charactes rather then one. The viable solution is to convert the data fetched from oracle to encoding "entityname". tht should solve the purpose for accented characters also.hope it helps.