Sage 100

Anyone know what controls the encoding of a csv file when exported from Crystal? On one server (with MAS 90 4.4), the file has ANSI encoding, while a different server (with 4.5, same export) has UTF-8. What am I missing?

Oh, man, I'm really curious about this, too. Suddenly started having UTF-8 files showing up all over unless I have them choose Legacy when exporting.

From our friend Mr. Google: Following information might help you to resolve the issue. ADAPT01103827 makes the presence of the Byte-Order Mark configurable via registry key. Fixed in FixPack 4.4 or Service Pack 5. Add or modify HKEY_CURRENT_USER\Software\Business ObjectsSuite 11.5\Crystal Reports\Export\CSV\IncludeUTF8BOM and HKEY_LOCAL_MACHINE\Software\Business ObjectsSuite 11.5\Crystal Reports\Export\CSV\IncludeUTF8BOM and set to 0 The article (http://scn.sap.com/thread/984018) is on Business Intelligence, but one of the posters posted this in reference to Crystal.

Thanks @RobertWood . Unfortunately, the registry does not have export settings. What I did notice is that crystal on the 4.5 CD is version 11.5.8.826 and my previous one is 11.5.12.1838. Perhaps the one with 4.5 CD isn't patched with SP6? Will download the patch and check again.

It says you have to have service pack 5.

I can confirm that the Byte Ordered Mark issue is resolved by the registry setting available in SP 6. A registry update to turn it off is attached.

Thanks Dan! Installed SP6 before I read this post and it appears to have fixed the issue.