I developed an application using Bottle web framework and Python, to import some data into MySQL database. Most of the data where in Greek characters. On my application side, i didn't any further encoding/decoding on input data.
Accessing my DB using the CLI and a simple select query, i get something like this :
| 1 | ????????? | ??????? |
When i browse my DB using the Sequel Pro application, i can read the characters regularly.
Using Sequel Pro, i can export the data into CSV and/or JSON.
Opening the output files using sublime Text, i get :
\u0394\u03b7\u03bc\u03ae\u03c4\u03c1\u03b9\u03bf\u03c2
from the JSON file. and
Δημήτριος
From the CSV file.
When i open the same (CSV) file on Excel (for MAC), i get something like this :
ΔημήτÏιοÏ
Any ideas how can i export the data, in a format that i can simply deliver to my colleagues without giving them too complicated details on how to open the file ?