I'm trying to remove Paragraphs and modules related to it manually (because I can't remove it completly from admin page).
I'm using UTF8 without BOM in Notepad++ when editing key_value BLOB file that I get form PhpMyAdmin and I see that error in my site:
Notice: unserialize(): Error at offset 76 of 42499 bytes in Drupal\Component\Serialization\PhpSerialize::decode() (line 21 of core\lib\Drupal\Component\Serialization\PhpSerialize.php).
My DB is in utf8mb4_general_ci. The change that I made into key_value table is removed a orphaned field and subtracted a value from the initial counter (a:37 to a:36 from that BLOB data).
I saw some php code related to serialize/unserialize but I think this problem could be solved from PhpMyAdmin without modifying core files. Looking for some hint.