0

I have a sql file with utf-8 charaset with inserting Japanese character like this.

CREATE TABLE CHAR_TEST(name varchar(100));
INSERT INTO CHAR_TEST(name) VALUES ("文字化け");

I upload this file to Cloud Storage and import this file from Cloud Sql, then the character is broken.

| name |
--------
| 文字化ã‘|

I use MySQL 8.0 with utf8mb4 charaset ,and the file is also utf-8. I checked these thing works.

  • Using Cloud SQL Proxy
  • Cloud Shell

Is there any way to do this works?

Peter
  • 393
  • 1
  • 3
  • 15
  • That's utf8 to mojibake. See https://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored Check the connection parameters. – Rick James Apr 18 '23 at 02:42

0 Answers0