search

ChuckBell / MySQL_Connector_Arduino

Database connector library for using MySQL with your Arduino projects.
331 stars 132 forks source link

Get UTF-8 characters #122

Closed JanB97 closed 4 years ago

JanB97 commented 4 years ago

Hi, so I need to get german names out of my database and unfortunately there are letters that are not part of the ASCII characterset. For example in my lastname is an ö (ö , oe) and with your library it gets displayed as "?". Is there any way to get this out as the right character, so possibly with UTF8? I tried to convert within my query, but it is not working.

I also tried inserting an ä (ä, ae) with your library and it is reading it back correctly, however with every other tool the encoding seems to be wrong (This is the output: ä).

JanB97 commented 4 years ago

Okay got it working with: CONVERT(CAST(column as BINARY) USING latin1). Thats good enough for me.