This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

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.

Regards

Felix

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.