Configure Amazon RDS mysql to store Chinese Characters
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 votefavorite 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 | +----------------------+-----------------+mysql amazon-rds shareimprove this question | edited Jul 27 at 22:46 Kara 3,12373147 | asked Jun 6 '13 at 3:24 Yujun Wu 1,19752442 |
[td] [/td]
add a comment
3 Answers
activeoldestvotes
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! |
相关推荐
CoderToy 2020-11-16
emmm00 2020-11-17
王艺强 2020-11-17
ribavnu 2020-11-16
bianruifeng 2020-11-16
wangshuangbao 2020-11-13
苏康申 2020-11-13
vivenwan 2020-11-13
moyekongling 2020-11-13
云中舞步 2020-11-12
要啥自行车一把梭 2020-11-12
aydh 2020-11-12
kuwoyinlehe 2020-11-12
minerk 2020-11-12
vitasfly 2020-11-12
jazywoo在路上 2020-11-11
敏敏张 2020-11-11
世樹 2020-11-11