Shoutbox problem emoijs + special characters

 
 
At the mo problem is this:

1. on opera, emoijs are in black and white
2. I have a problem with some special characters ...  give such &period or &comma
...

With the database 7.1 I have no problem but I'm collating latin1_swedish_ci and I can not do it with the new Table 7.2 in the shoutbox ... since the field format "message" is no longer "text" but "blob" ...
Baloo
Quote · 22 Jul 2015

Please could you clarify what are the problems with period and comma characters?

Emoji are multibyte characters, so to be able to save it in the database we used blob field type.

Also if you have MySQL 5.5 or higher you can try to use utf8mb4 charset.

ALTER TABLE bx_shoutbox_messages charset=utf8mb4, MODIFY COLUMN Message TEXT CHARACTER SET utf8mb4;
Rules → http://www.boonex.com/terms
Quote · 24 Jul 2015

Thank you but does not work for me

Manually when the message type = blob phpmyadmin refuses to back the "interclassement"

Your order this product "Message text utf8mb4_general_ci Yes NULL."

Blob is replaced by text ...

MySQL: 5.5.43-0 + deb7u1 - OK

Baloo
Quote · 24 Jul 2015

Yes, you can't choose table field collation when the type is BLOB, also you can't see the content of BLOB field in phpMyAdmin, but it still works on the site, since site know what text encoding to use.

Also it's better to check with new posts in Shoutbox after changing field type.

Rules → http://www.boonex.com/terms
Quote · 27 Jul 2015
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.