database - COLLATION_NAME change mysql amazon RDS -


i using amazon rds mysql 5.6. problem database not case sensitive. ex. unable insert 'deepesh' , 'deepesh' values in primary key column.

as per on line solution need change collation_server. current collation_server utf8_general_ci , character_set_name utf8.

pls suggest how can change , impact on system, db size 500gb time.


Comments