0

We are using pymysql to import data from our Windows Network Desktops to our Ubuntu Server database for Superset. For intern reasons we need to drop the table and create it as a new one every time when we import our dataset.

Everything is working fine, except this error in the first tablecolumn. So the Tablecolumnname Gesellschaft will be changed to ?Gesellschaft in superset. It doesn't matter which word we use, it is always the first tablecolumnname.

I am pretty sure everything is in utf-8

This is how it looks in superset:

enter image description here

.

And this how it looks via ssh mysql access:

dubstep22
  • 41
  • 1
  • 7
  • 1
    MySQL isn't known for randomly generating data when inserting. This looks like some sort of encoding issue to me, so I would start looking there for a solution. – Tim Biegeleisen Jan 18 '18 at 11:28
  • Looks like you have some invisible/unsupported symbol in the string. Did you try deleting it and typing the same thing by hand? Also, you need to use `utf8mb4` if you want full UTF-8 support (mysql's `utf8` works only up to 3 byte sequenses). – Vatev Jan 18 '18 at 13:52

0 Answers0