Project

General

Profile

does tigase support utf8mb4?

Raylin lin
Added almost 5 years ago

hi,all:

  iOS and Android mobile app can send emoji (which may have 4 bytes) in message,but tigase can not save them into database. this thread(https://projects.tigase.org/boards/4/topics/1977?r=2061) can not solve this problem very well.

Replies (4)

Avatar?id=6023&size=32x32

Added by Artur Hefczyc TigaseTeam almost 5 years ago

Yes, the Tigase can save UTF8 characters to database. It all depends on a correct DB configuration.

Added by Wojciech Kapcia TigaseTeam almost 5 years ago

Raylin lin wrote:

tigase can not save them into database.

As described in the linked thread - Tigase can easily store and receive messages containing emoji - https://projects.tigase.org/boards/4/topics/1977?r=2061#message-2061; are you sure your DB configuration is correct? How does your db-uri in Tigase look like?

Added by Raylin lin almost 5 years ago

hi Wojciech Kapcia:

  my db-uri looks like this:

--user-db-uri=jdbc:mysql://10.62.10.45:3306/imchat?user=admin&password=newbooone&noAccessToProcedureBodies=true&useUnicode=true&characterEncoding=utf-8

Added by Wojciech Kapcia TigaseTeam almost 5 years ago

Have you configured your MySQL as described in Configuring MySQL for UTF-8 support Does saving any other non-ascii, non-emoji characters works?

    (1-4/4)