I haven't set up any DSN and using any SQL yet. Just plain Chinese in HTML and CFM files. Just that Simple.
I can sent you one of the HTML file, you can open it from your local machine using IE browser, it will display correctly.
Here is the code
----------
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head><title>Chinese in Seattle ????? ???? ???? ??? ???? ??????????????? - Your Community</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="Chinese in Seattle" content="Chinese, Seattle, default">
<meta name="description" content="Chinese in Seattle ????? ???? ???? ??? ???? ??????????????? - Your Community">
<meta http-equiv="keywords" content="Seattle, Washington, Chinese, Chinese in Seattle, Chinese USA, China Washington, Dating, Saettle Chinese,Chinese, immigrant, life, friends, friendship,international friendship, job, tourism, study, university, school,language,education" />
<!--- STYLESHEETINCLUDE --->
<link rel="stylesheet" href="style/cis.css" />
<!--- To define the banner flash border color with the bottom script style flashgroup border:3px solid red;style --->
<!--- END HEADINCLUDE --->
<script language="Javascript" type="text/javascript">
startList = function() {
if (document.all&&document.getElementById) {
navRoot = document.getElementById("nav");
for (i=0; i<navRoot.childNodes.length; i++) {
node = navRoot.childNodes
;
if (node.nodeName=="LI") {
node.onmouseover=function() {
this.className+=" over";
}
node.onmouseout=function() {
this.className=this.className.replace(" over", "");
}
}
}
}
}
window.onload=startList;
function launch_support_1()
{
var date = new Date();
var unique = date.getTime();
newwin = window.open('http://www.chineseinseattle.com/request.cfm?l=cis&x=1&deptid=1', unique, 'scrollbars=no,menubar=no,resizable=0,location=no,screenX=50,screenY=100,width=450,height=350' ) ;
newwin.focus() ;
}
function print_mail_to_link() {
var lhs = "contact";
var rhs = "chineseinseattle.com";
document.write("<A HREF=\"mailto");
document.write(":" + lhs + "@");
document.write(rhs + "\">" + "Contact Us" + "<\/a>");
}
</script>
<script src="http://netWeather.accuweather.com/adcbin/netWeather/runNetWeather.js" language="JavaScript" type="text/javascript"></script>
<script src="http://netWeather.accuweather.com/adcbin/netWeather/setNetWeather.js" language="JavaScript" type="text/javascript"></script>
<script language="javascript" src="style/tree.js"></script>
</head>
<body leftmargin=0 topmargin=0 marginheight="0" marginwidth="0" class="mybody">
<!--- MenuHeader.html images/cistitle2.gif
<table width="100%" cellpadding="0" cellspacing="0" border="0" align="center">
<tr>
<td style="padding:0px 0px 0px 0px">style="padding:0px"--->
<div class="cishead" id="cishead">
<table cellpadding="0" cellspacing="0" border="0" width="100%" align="center">
<tr>
<td class="alt1" align="left" width="10%">
<img src="images/seattle/seattle-clip4.gif" alt="Seattle Chinese">
</td>
<td class="alt1" align="center" width="90%" valign="bottom">
<table cellpadding="0" cellspacing="0" border="0" width="100%" align="center">
<tr>
<td class="alt1" align="center" valign="top">
<script language="JavaScript" src="style/rotateimage.js"></script>
<a href="http://www.dpbolvw.net/ba107hz74z6MOTNNQRVMOWPSPTQ" target="_blank" onmouseover="window.status='http://affiliates.ebay.com';return true;" onmouseout="window.status=' ';return true;"></a>
<br><br>
</td>
<td class="alt1" align="center" valign="bottom">
<img src="http://banners.wunderground.com/banner/krd_cond/language/www/US/WA/seattle.gif">
</td>
</tr>
<tr>
<td align="center" valign="bottom">
<table align="center" cellpadding="0" cellspacing="0" border="0">
<tr valign="bottom">
<td class="tcat" valign="bottom">
<a href="index.cfm?page=main">???</a> <font color="#FFFFFF">|</font>
<a href="http://www.chineseinseattle.com/cisforum/index.php">??????</a> <font color="#FFFFFF">|</font>
<a href="index.cfm?page=activity&subcat=eventnews">??????</a> <font color="#FFFFFF">|</font>
<a href="index.cfm?page=cismatch&subcat=matchmain">???????</a> <font color="#FFFFFF">|</font>
<a href="index.cfm?page=buysell&subcat=buysellsrchads">??????</a> <font color="#FFFFFF">|</font>
<a href="index.cfm?page=newmember&subcat=memberjoincis">???????</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<!-- </td>
</tr>
</table>--->
--------------------------
Stephen said:
I had over 12 hours with no power to think about this, it sounds more like the database than the CF server, we may need to recreate your DSN to support UTF, also we may need to set the language if it is using SQL server. Remember SQL is on a different server in our(and most) Hsphere networks, and Access is on the same as web server, but may not have UTF support when the DSN is created.