Skip to main content
F
fenwicktang
Participant
July 28, 2011
Question

CF9 cffile (utf-16) Issue

  • July 28, 2011
  • 1 reply
  • 649 views

Dear all,

Could you please advise how can I generate a file using cffile with charset="unicode" or "utf-16", and the file can be shown in MS Excel correctly?

I have used charset="unicode" that works perfect to me (can open in MS Excel with Chinese and Japanese words).

But after upgraded to CF9, MS Excel cannot detect the correct charset the file using, so that the file content cannot be shown.

The casue seems like the file generated is UTF-16BE insteads of UTF-16LE, but I cannot find any setting related in Coldfusion Admin page....

Please help....

Thanks.

Best Regards,

Fenwick

    This topic has been closed for replies.

    1 reply

    T
    tooMuchTrouble
    Inspiring
    July 29, 2011

    On 7/28/2011 5:45 PM, fenwicktang said:

    I have used charset="unicode" that works perfect to me (can open in MS Excel with Chinese and Japanese words).

    i don't believe "unicode" was ever a proper "charset" (encoding) though i guess

    it's little endian, UTF-16LE. have you tried charset="UTF-16LE" in your cffile?

    and what exactly are you seeing that's not "correct" in your spreadsheet?

    btw cf9 has the new cfspreadsheet tag, where you can read/write/update

    spreadsheets as XLS files. you might give it a try.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices