Hi folks
I’m using ST3 with a mysql build querying in MAMP 3.5 running a 5.7 mysql.
My results show ? for all latin accentuated characters (and also the middle dot)
I tried to change the encoding of the table column to various other options with no luck.
(please note: everything looks fine when using phpmyadmin or the app itself)
I do not have this issue in ST4 using a similar mysql build
Any input on how to display accentuated characters with an ST3 mysql build?
Do you run those mysql commands on Windows?
ST’s build system expects executed programs to output utf-8 encoded textby default.
Windows terminal applications however output strings with oem encodings using codepages like 850, 437 etc.
Therefore various non-ascii chars are not decoded correctly in build output panel.
On ST4 you can set "encoding": "oem" to fix it.
On ST3 you need to determine your codepage and set encoding accordingly (e.g.: "encoding": "cp850").
Running on Mac, Apologies for the lack of context.
My ST4 build runs fine without any helper for encoding