Skip to main content
Participant
March 31, 2014
Question

Chinese Character display issue on Coldfusion 10

  • March 31, 2014
  • 2 replies
  • 1497 views

My Company using Coldfusion to built an report platform and recently I upgrade our Coldfusion 7MX with Windows Server 2003 to Coldfusion 10 Enterprise with Windosw Server 2008 R2.

I copy the Code from the Old server to the new one, but I met the problem I couldn’t solve.

We have a repost that can enter, modify and view our SRM that has Chinese Character display request. Chinese character was display without problem when the system in the old server. which look like following.

once I move the code into the new server, I got the problem with Chinese Character as following.

This report pulling the data from SQL2005 with Windows Server 2003 R2.

Coldfusion code code was same and both version is access to the same database.

I ran all of the update included to install the windows MUI for Chinese character into the new server,  but I still can't get the character display correctly.

I can view the chinese character website without issue but only to display in the report.

I contact with Microsoft tech support but they don't have an solution for me. please help.

    This topic has been closed for replies.

    2 replies

    Inspiring
    April 11, 2014

    Try using charset="GB2312"  if UTF-8 isn't working.  I pull data from Baidu and for some of their webservices UTF-8 works, but for others GB2312 is needed.  The third possibility is "Big5".

    Good luck,

    -reed

    BKBK
    Community Expert
    Community Expert
    April 1, 2014

    It seems to be an encoding problem. Set the encoding in whatever is displaying the report to UTF-8 or any other compatible charset.

    TRPC_ITAuthor
    Participant
    April 11, 2014

    Hi,

    Thank you for your suggestion, I tried it to set my meta with "<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />" and adding a code as  "<cfprocessingdirective pageencoding="utf-8">" but still showing as following..

    I also tried to created table with different Chinese character since I thought it may  be the table issue, but it end up same. thank you.

    WolfShade
    Legend
    April 11, 2014

    AFAIK, there is no comprehensive list of differences between CF7 and CF10, nor a list of deprecated tags (which is the first thought that popped into my head after reading the original post - how many tags have been deprecated between the two).  This may be more than an encoding issue.  I think it might also depend upon how the Chinese text is stored in the database.

    ^_^