Skip to main content
August 7, 2009
Question

Unicode problem CFMX7 Firefox works but Internet Explorer doesn't

  • August 7, 2009
  • 1 reply
  • 901 views

I am having a pecular issue here with updating a MSSQL2000 db using cfmx7. When i post unicode using firefox it goes in the database fine and it's viewable fine using either FF or IE, but when I post unicode using IE, it goes into the database as question marks.

You can see the top two postings at http://isajha.com to see the difference in postings using FF vs IE. Your help is appreciated.

To test it you can use the following username/password

username: demouser

pasword: demouser

    This topic has been closed for replies.

    1 reply

    Inspiring
    August 7, 2009

    if the front & back end code's the same for both browsers (is it?) then perhaps

    the IE user's browser was using another encoding (question marks indicate data

    garbaged by encoding).

    do your cf pages have a BOM? it's not really required for utf-8 but some s/w

    might not be able to figure out the page encoding w/out it.

    what version of IE?

    August 7, 2009

    Hi Paul, thanks for your reply.

    The front and back end code is same except for using the following javascript components for ajax calls.

    XMLHttpRequest() (for firefox)

    ActiveXObject("Msxml2.XMLHTTP")
    ActiveXObject("Microsoft.XMLHTTP") these two for IE depending on whichever is returned.

    I have put <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> on top of the page and <cfprocessingdirective pageencoding="UTF-8">  on application.cfm

    what bugs me is it works on FF but not on IE :s I tried both IE7 and IE8

    I am not using any BOM how does one use it?

    August 14, 2009

    Still waiting for any pointers on this