Database collation and create tables via update

[Fenton1]

Hi there,

I posted it on the MODX Forum as well, maybe someone here got an idea, it only affects the first 3 rows of the DB:
https://forums.modx.com/thread/104552/after-update-to-evo-1-4-5-database-charset-is-set-to-latin1-even-though-database-is-set-to-utf8

thanks a lot, j

[AgelxNash]

https://mediatemple.net/community/products/dv/204403914/default-mysql-character-set-and-collation

[Fenton1]

thanks AgelxNash,

but still, why did it change during the upgrade process for the first 3 rows? happened on another site as well and I checked beforehand, that it was indeed utf8_general_ci

cheers, j

[AgelxNash]

@Fenton1
EvolutionSMS when updating removes and creates new tables

• active_users
• active_user_locks
• active_user_sessions

When creating tables, your server uses the latin1_german2_ci encoding. The latin1_german2_ci is default encoding on your server.

[AgelxNash]

@Fenton1 Use advanced upgrade

[Fenton1]

@AgelxNash ah! that explains it :)

"EvolutionSMS when updating removes and creates new tables"

thanks a lot! updated a few sites to the current Evolution version and it looks great

cheers, j

[Fenton1]

yes, I used Advanced Upgrade already