2
0

test with emoticon ?


 invite response                
2017 Dec 17, 3:46pm   1,475 views  11 comments

by Patrick   ➕follow (55)   💰tip   ignore  

Comments 1 - 11 of 11        Search these comments

2   Patrick   2017 Dec 17, 3:48pm  

OK, it looks like I fixed the database so that you can now include emoticons in your posts or comments.
3   Patrick   2017 Dec 17, 5:05pm  

你可以寫這個
4   Patrick   2017 Dec 17, 5:05pm  

Вы можете написать это тоже.
5   Rew   2017 Dec 17, 5:06pm  

:)
6   Patrick   2017 Dec 17, 5:09pm  

And other character sets work OK as well.

Here was the solution for comments:

alter table comments convert to character set utf8mb4;

Was a little harder for posts (threads) because the titles are indexed, and index keys may not be longer than 1000 bytes. Titles were 255 chars max, but when you use utf8mb4 you are using 4 characters per byte, and 255 * 4 = 1020 bytes. So I had to reduce max title length to 250 for posts, but that didn't affect any existing titles.
7   MisdemeanorRebel   2017 Dec 17, 5:17pm  

хихи хихи

;) 8)
8   anonymous   2017 Dec 17, 8:31pm  

???
9   anonymous   2017 Dec 17, 8:31pm  

???
10   anonymous   2017 Dec 17, 8:31pm  

???
11   anonymous   2017 Dec 17, 8:31pm  

It works. ??

Please register to comment:

api   best comments   contact   latest images   memes   one year ago   random   suggestions