Configure Amazon RDS mysql to store Chinese Characters

-Advertisement-

Configure Amazon RDS mysql to store Chinese Characters https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html http://docs.aws.amazon.com/AW ...

Configure Amazon RDS mysql to store Chinese Characters

https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html

http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-rds-database-instance.html#cfn-rds-dbinstance-charactersetname

http://stackoverflow.com/questions/16953232/configure-amazon-rds-mysql-to-store-chinese-characters

up vote5down vote favorite 1

How to configure the Amazon RDS to store Chinese Characters in the right way? Currently the text all becomes '????'.

I already created new parameter group and set character set as utf8 and modify the instance. Below are the detail info:

mysql> show variables like '%char%';
+--------------------------+-------------------------------------------+
| Variable_name            | Value                                     |
+--------------------------+-------------------------------------------+
| character_set_client     | utf8                                      |
| character_set_connection | utf8                                      |
| character_set_database   | utf8                                      |
| character_set_filesystem | binary                                    |
| character_set_results    | utf8                                      |
| character_set_server     | utf8                                      |
| character_set_system     | utf8                                      |
| character_sets_dir       | /rdsdbbin/mysql-5.5.27.R1/share/charsets/ |
+--------------------------+-------------------------------------------+


+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database   | utf8_general_ci |
| collation_server     | utf8_unicode_ci |
+----------------------+-----------------+

shareimprove this question

edited Jul 27 at 22:46

Kara 3,12373147

asked Jun 6 '13 at 3:24

Yujun Wu 1,19752442

add a comment

3 Answers

active oldest votes

up vote9down voteaccepted

After following @Peter Venderberghe's answer to configure RDS, I still can not let it store Chinese characters correctly.

Finally, I used mysql command line to connect to RDS (you can use mysql workbench or other client tool you like)

mysql -u USERNAME -pPASSWORD -h HOSTNAMEORIP DATABASENAME

note:

1). remember to add your current ip to security group inbound of RDS before connecting to RDS

2). you can get related information(security groups, USERNAME...etc) on RDS console besides PASSWORD. PASSWORD should be the one you created for the instance. HOSTNAMEORIP is "Endpoint"(without the port) on the console.

3). there is no space between -p and PASSWORD. it's exactly -pPASSWORD.

After connecting to mysql with the tool you are comfortable with, you need to give it some commands:

# set character set and collation for database
mysql> alter database DATABASENAME CHARACTER SET utf8 COLLATE utf8_unicode_ci;
--------
# set character set and collation for new records in a table
mysql> ALTER TABLE TABLENAME CHARACTER SET utf8 COLLATE utf8_unicode_ci;
# set character set and collation for existing records in a table
mysql> ALTER TABLE TABLENAME CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

you may want to write a script to do this task if you have many tables. However, it's not in the scope of this answer.

After configuring as above, you should be able to rock with Chinese characters!

您的分享是我們最大的動力!

-Advertisement-

更多相關文章

資料庫知識總結

Chpt 1 一、基本名詞 1.資料庫：實際上是一個信息列表 2.資料庫程式：虛擬的列表管理員 3.表：只用於存儲一類事情的信息，保持不同信息分類之間的獨立性可以讓資料庫以一種嚴密的組織方式高效地存儲信息 4.行/記錄：每一行都包含一個（且只有一個）由表名稱定義的項目信息 5.列/欄位：包含特定事物 ...
【方法整理】Oracle 獲取trace跟蹤文件名的幾種常用方式

【方法整理】Oracle 獲取trace跟蹤文件名的幾種常用方式 1 BLOG文檔結構圖 2 前言部分 2.1 導讀和註意事項各位技術愛好者，看完本文後，你可以掌握如下的技能，也可以學到一些其它你所不知道的知識，~O(∩_∩)O~： ① trace跟蹤文件的獲取 Tips： ① 本文在itpub（... ...
sql server查詢可編程對象定義的方式對比以及整合

本文目錄列表： 1、sql server查看可編程對象定義的方式對比 2、整合實現所有可編程對象定義的查看功能的存儲dbo.usp_helptext2 3、dbo.helptext2的選擇性測試 4、總結語 5、參考清單列表本文目錄列表： 1、sql server查看可編程對象定義的方式對比 2、 ...
基於MySQL MEB的備份恢復

MEB（MySQL Enterprise Backup）是MySQL商業版中提供的備份工具，屬於物理備份。同XtraBackup一樣，mysqlbackup的使用過程同樣包含如下三個步驟：備份（--backup）=> 應用日誌（--apply-log）=> 恢復（--copy-back）備份 ...
SQL獲取資料庫名，表名，列名，說明等信息

...
從零自學Hadoop(20)：HBase數據模型相關操作上

上一篇，我們講述了HBase的介紹及安裝，從列圖和引用的方式，列舉的HBase能做什麼及一些特點，也截圖了HBase的安裝過程。　下麵我們開始介紹HBase的數據模型相關操作，該部分內容較多，分成兩個部分。 ...
HIVE數據操作

Hive數據操作 1.向管理表中裝載數據 1.向管理表中裝載數據 hive沒有行級別數據插入、數據更新和刪除操作。採用“大量”的數據裝載操作，或者通過其它方式僅僅將文件寫入到正確目錄下。 LOAD DATA LOCAL INPATH '${env:HOME}/california-employee ...
SQLServer中ISNULL和CONVERT函數

create view sss as(select ISNULL(operate_time, CONVERT(VARCHAR(20),create_time,120)) time from s_project); 一、ISNULL()函數 (oracle中為nvl()函數) ISNULL()函數使 ...