problem to insert non-ASCII characters
Hi, I have a hard time trying to insert values with non-ascii characters. I'm using xampp, Windows, the command line, chcp 65001 done.
CREATE DATABASE test2; ALTER DATABASE test2 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; USE test2; CREATE TABLE autoren (name VARCHAR(50) NOT NULL); INSERT INTO autoren VALUES('安部公房');
The prompt shows '> , but nothing is executing. I can leave only by CRTL+C.
INSERT INTO autoren VALUES('Abe Kobo');
works fine. If I change the name to "Köbö" this already causes the problem described above.
I can insert Japanese importing a file with myphpAdmin, and the table is displayed properly in the command line. Since I'm not using any 4 byte characters it shouldn't be an issue with utf8mb4 (which didn't work either).
Any suggestions are very welcome.