The Ultimate Guide to High Availability with MariaDB

problem to insert non-ASCII characters

You are viewing an old version of this question. View the current version here.

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.

Regards

Felix

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.