I'm sure this is an encoding issue, but I can't figure it out.
I exported a spreadsheet from Excel as a UTF-8 CSV. This produced a CSV in the UTF-8-BOM character encoding. Opening this file in Notepad++, most of the characters were rendered correctly – including non ANSI characters like ø. However, a hyphen ( ‐ ) is displayed as ☐.
I believe the character is U+2010 ‐ HYPHEN.
If I open the file in Notepad, the hyphen displays correctly. It also displays correctly if I use Vim to read the file or cat to print it out to the terminal.
Finally, the octal dump of the file reveals the hex bytes e2 80 90, which is the UTF-8 encoding of the U+2010 - HYPHEN Unicode character.
So why is Notepad++ displaying this character as ☐?
Best Answer
If other characters are being decoded properly and the byte-level data looks correct, it's possible the issue is just with the font. U+2010 is high up enough that some fonts might just not have a glyph available.
This answer to another Super User question states that a number of common Windows 7 fonts don't have the glyph for HYPHEN.