Could someone please explain what has changed in Windows 7 (Pro 64-bit)?
Details:
Previously I had Windows XP and had some translations files (UTF-8 encoded) in CSV format. I was able to view the fonts in both Notepad and Excel. After upgrading to Windows 7, when I open these files — all I see is square boxes (just you know, if I open them in browser — I was able to see all the translation). If I save those files in Unicode, everything seems to be fine.
So, what exactly is going on?
Why does Windows 7 work with Unicode and not with UTF-8?
Best Answer
Terminology
Unicode and UTF-8 are not the same kind of thing: Unicode is a character-set that defines a set of characters (a repertoire) and assigns numbers (code points) to each of those characters. UTF‑8 is one of several encodings that can be used to represent a stream of Unicode characters on disk or in transmission. The same stream of Unicode characters could also be encoded as UTF‑16, UTF‑32 or UTF‑7, for example.
However, Notepad offers you "encoding" options including
ANSI
,Unicode
,Unicode big-endian
andUTF-8
. The Microsoft developers who wrote this have used the wrong terms. When they say "Unicode" they most likely mean "UTF-16 little-endian". When they say "ANSI" they mean Code Page 1252 (CP-1252).Microsoft Notepad
I believe Microsoft's Notepad writes UTF-16 with a byte order mark (BOM) and that Notepad looks for the BOM when reading a text file. The BOM tells the app that the file is UTF-16 and indicates whether it is big-endian or little-endian.
If Notepad doesn't find the BOM, it calls a library function
IsTextUnicode
, which looks at the data and attempts to guess what encoding was used. Sometimes (inevitably) it guesses incorrectly. Sometimes it guesses that an "ANSI" file is "Unicode". Trying to interpret a UTF-16 or UTF-8 file as Code Page 1252 would cause it to display the wrong glyphs and be unable to find glyphs to render some 8-bit values – these would then be shown as squares.As harrymc says in his answer, there are better alternatives to Notepad. But Notepad lets you explicitly choose the encoding when opening a file (rather than leaving Notepad to try to guess).
Byte Order Marks
According to the Unicode consortium, Byte Order Marks (BOMs) are optional. However, Windows relies on BOMs to distinguish between some encodings.
So in short, maybe your files lacked a BOM for some reason? Maybe the BOM was lost sometime during the upgrade process?
If you still have the original files that show as squares, you could make a hex dump of them to see if they contain a BOM.
Plain text file standards
The problem is that there are effectively none – no universal standards for plain text files. Instead we have a number of incompatibilites and unknowns.
How have line-endings been marked? Some platforms use the control-characters Carriage Return (CR) followed by Line Feed (LF), some use CR alone and some use LF alone.
Are the above terminators or separators? This has an effect at the end of a file and has been known to cause problems.
Treatment of tabs and other control characters. We might assume that a tab is used to align to a multiple of 8 standard character widths from the start of the line, but really there is no certainty to this. Many programs allow tab positions to be altered.
Character set & Encoding? There is no universal standard for indicating which of these have been used for the text in the file. The nearest we have is to look for the presence of a BOM which indicates the encoding is one of those used for Unicode. From the BOM value the program reading the file can distinguish between UTF-8 and UTF-16, etc., and between Little-Endian and Big-Endian variants of UTF-16, etc. There is no universal standard for indicating that a file is encoded in any other popular encoding such as CP-1252 or KOI-8.
And so on. None of the above metadata is written into the text file – so the end-user must inform the program when reading the file. The end-user has to know the metadata values for any specific file or run the risk that their program will use the wrong metadata values.
Bush hid the facts
Try this on Windows XP.
Save As
. From theEncoding
menu, selectANSI
.Start
,My Recent Documents
).This illustrates that the
IsTextUnicode
function used by Notepad incorrectly guesses that the ANSI (really Code Page 1252) text is Unicode UTF-16LE without a BOM. There is no BOM in a file saved asANSI
.Windows 7
With Windows 7, Microsoft adjusted
IsTextUnicode
so that the above does not happen. In the absense of a BOM, it is now more likely to guess ANSI (CP 1252) than Unicode (UTF-16LE). With Windows-7 I expect you are therefore more likely to have the reverse problem: A file containing Unicode characters with code points greater than 255, but with no BOM, is now more likely to be guessed as being ANSI – and therefore displayed incorrectly.Preventing encoding problems
Currently, the best approach seems to be to use UTF-8 everywhere. Ideally you would re-encode all old text files into UTF-8 and only ever save text files as UTF-8. There are tools such as recode and iconv that can help with this.