mahara-contributors team mailing list archive

[Heena Agheda <1895259@xxxxxxxxxxxxxxxxxx>]

I have changed table collation and field character set:

ALTER TABLE block_instance CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE block_instance modify configdata text charset utf8mb4;

ALTER TABLE view CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE view modify description text charset utf8mb4;

Also change line:1751 in /htdocs/lib/dml.php 
$db->_Execute("SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci");


** Attachment added: "dml.php"
   https://bugs.launchpad.net/mahara/+bug/1895259/+attachment/5409668/+files/dml.php

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1895259

Title:
  Unable to see emoji on page description and text content

Status in Mahara:
  New

Bug description:
  - exact version of Mahara - 20.04 - master branch
  - operating system - Ubuntu 18.04.5 LTS
  - database - MySQL 5.7

  Emoji's are turning into '?' while adding them on 'Page description'
  of Page.

  Also When you add the New Block -> Content type -> Text - in 'Block
  content' adding emoji removes all content of the block. Its stored in
  database but because its converted into '?', content of serialized not
  matching with content length.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1895259/+subscriptions