Japanese characters transcoding: stop using Shift-JIS for the source

So, last day I got an encoding error. The data is what I though was in Shift-JIS but it could not be converted to UTF-8 because in Shift-JIS U+0087 does not exists.

It's is multiple used as title like so:



In Windows, apparently, instead of the strict Shift-JIS, they are using CP932 which is superset of Shift-JIS (meaning it's Shift-JIS with additional characters).

Please use CP932 encoding when dealing with Japanese characters.

The Rubyist out there, it will be:

CSV.read("csvfile.csv", encoding: "CP932:UTF-8")