Reply to thread

Hi!


I have on my old SMF this thread:

http://hablajapones.org/foro/preguntas-comentarios/kanjis-suplementarios/new/#new

[ATTACH=full]93370[/ATTACH]


But I create the same thread on XenForo, and I can't post it.

[ATTACH=full]93368[/ATTACH]


The caracters are from here:

http://www.i18nguy.com/unicode/supplementary-test.html

[ATTACH=full]93369[/ATTACH]



Something I noticed is that they are 4-bytes UTF-8. Since MySQL utf8 datatype only supports up to 3 bytes, I think XenForo is not supporting whole 1-4 UTF-8 spectre, only BMP (as I read on other threads).


I already modified the DB (utf8mb4), and inserted those characters directly into mysql and I can read/visualize those kanjis in XenForo

[ATTACH=full]93372[/ATTACH]


So it seems before you try to store the data in the database, you "clean" the input from the text fields.


1) Any plans for supporting utf8mb4 on MySQL 5.5.3+?

2) Any easy way for me to change something in Xenforo that will allow me to post and save utf8 of 4 bytes, now that my database allows it?


Thanks!


Back
Top Bottom