CF9 cffile (utf-16) Issue

Report · Jul 28, 2011

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

Report · Jul 28, 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.