Column ps_cms_lang.meta_description should use character set utf8mb4/utf8mb4_unicode_ci instead of utf8/utf8_general_ci

[Havouza]

This is from my update to 1.3. This is an example, the db has to have a different charset all over. I tried to solve in by running sql

ALTER DATABASE db_jv80 CHARACTER SET utf8_general_ci COLLATE utf8mb4_unicode_ci

But get error

#1115 - Unknown character set: 'utf8_general_ci'

Any sql guru here

TIA

[the.rampage.rado]

As I said in the other thread - don't be bothered by the 'dangerous' note next to those lines - hit apply to all of them as your backup is recent enough!

This change in particular only fixes potential issues regarding the encoding of some chars in this table.

Also your db name is visible, this is sensitive info! 😉 
 

 - where I had some similar issues. May help you too.

Edited July 6, 2022 by the.rampage.rado

[Havouza]

@the.rampage.rado

2 lines I cant change from BO or phpmyadmin. get this error

Column ps_shop_url.virtual_uri should use character set utf8mb4/utf8mb4_unicode_ci instead of utf8/utf8_general_ci

Specified key was too long; max key length is 1000 bytes