Recommended db settings

[ugintl]

What is the recommended db charset and collation for CI 3?

[surepeps]

@ugintl by default charset comes with cl3 setting Check the following path "application/config/database.php" But you can change it if you want just that for every tables must have charset utf8mb4 engine

[ugintl]

@surepeps Thanks. I have a CI 3 app which is using latin1_swedish_ci for database and utf8_general_ci for tables. Is it ok?

[kirilkirkov]

@ugintl utf8_general_ci is better encoding, so i suggest you to change the tables which are latin1_swedish_ci to utf8_general_ci