Re: Northwind DB and character encoding
> commmand window mysql interpreter
Possibly cmd is set to the wrong "code page".
Have you specified "SET NAMES utf8mb4"?
Do
SELECT HEX(city) FROM ...
That will provide information that lets us decide whether the INSERT is broken or the SELECT is broken. After that, we can plan how to fix it.
A lengthy discussion about related topics:
http://mysql.rjweb.org/doc.php/charcoll
Subject
Written By
Posted
Re: Northwind DB and character encoding
May 07, 2014 10:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.