4 ms·
I'm pretty sure the reason only some of the currency symbols aren't correct has to do with the database. If you think about it, the item names are most likely
by arielm 9y ago
I'm pretty sure the reason only some of the currency symbols aren't correct has to do with the database.
If you think about it, the item names are most likely coming from a database that just might not be in the right encoding (latin1 is still the default in MySQL I think). The symbols that do work are probably hard coded into the receipt's template, and hence don't have this problem.
Why a shop owner would store the price and currency symbol in an item's description is beyond me, but having worked in the POS world and seeing what shop owners do with their items I'd definitely believe it.
- sixothree 9y ago> Why a shop owner would store the price and currency symbol in an item's description is beyond me... Have you never watched Pulp Fiction? https://www.youtube.com/watch?v=zoJAc_aSM7E https://www.youtube.com/watch?v=zoJAc_aSM7E This video will explain exactly why a vendor might put a price in the description field.
- jgust 9y ago> Why a shop owner would store the price and currency symbol in an item's description is beyond me If you've worked in the POS world you know exactly why: bad software. It either doesn't support the use case the owner has or isn't easy to use.
- deleted 9y ago[deleted]
- eponeponepon 9y agoShop owners (almost) invariably just bash their price lists into a spreadsheet or a Word file. A lot of this can be reasonably blamed on their only tools being hammers, so to speak.
- morgo 9y agoIndeed, latin1 is currently the default for MySQL. But it changes to utf8 in MySQL 8.0 (in development).
- lmm 9y agoNote that the encoding that MySQL calls "latin1" (and uses as its default) is not, in fact, latin1. It is windows cp1252 except with 8 random characters swapped around. I wish I was joking.
- 0x0 9y agoHaha, and what mysql calls "utf8" is not, in fact, all of utf8. That's called "utf8mb4".
- Joeri 9y agoIt also can't sort unicode correctly according to the standard UCA algorithm. The ticket for this is closed as a wontfix.
- s_kilk 9y agoJesus Christ. Is there a reason for this? Or is it just another case of lol@mysql
- vatotemking 9y agoSo in 2017, whats the correct character set to use in MySQL?
- lmm 9y ago"utf8mb4", though really in 2017 the correct thing is to use Postgres.
- vatotemking 9y agobut not everyone can use postgres
- lmm 9y agoAnyone can if they want to enough. Some don't want it enough, or want other things more, but not using postgres is always a choice.