CODEWITHSUNDEEP
amazon-web-servicesutf-8amazon-rds
Noriaki Takamizawa
Noriaki Takamizawa

Reputation: 1049

How to apply utf-8 to RDS

I'm using RDS on ElasticbeansTalk of AWS. As I noticed Japanese character on RDS, I tried to change settings on RDS parameter group like this. RDS

And this

enter image description here

Even though I modified some settings, the configuration didn't still work.

No matter what I import csv data including Japanese character, the table is getting like this.

MySQL table data

How should I do? Could you tell me how to apply utf-8 on existing RDS(EB) tables? Thanks in advance.

Upvotes: 3

Views: 6346

Answers (1)

Noriaki Takamizawa
Noriaki Takamizawa

Reputation: 1049

I figured out by myself. All I have to do is to apply some SQL.

ALTER TABLE (table name) CONVERT TO CHARACTER SET UTF8

Sorry for bothering.

Upvotes: 8

Related Questions