Announcement

Collapse
No announcement yet.

emoji and utf-8

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    hello wayne,

    we have converted to utf8mb4_unicode_ci. do i have to do anything?


    Click image for larger version

Name:	closure.jpg
Views:	64
Size:	116.4 KB
ID:	4428409



    Click image for larger version

Name:	nodde.jpg
Views:	36
Size:	199.0 KB
ID:	4428410



    Click image for larger version

Name:	text.jpg
Views:	29
Size:	177.6 KB
ID:	4428411
    https://www.vbulletin.com/forum/foru...re-waiting-for

    Comment


    • #17
      You've done this on all 203 tables in the database? The images really don't provide any kind of picture that would help me help you more.

      Did you use the database conversion scripts we provide in your vBulletin Download? They actually convert the data in the tables and don't just change settings.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API - Full / Mobile
      Vote for your favorite feature requests and the bugs you want to see fixed.

      Comment


      • #18
        Hello,

        - all tables are converted.
        - we converted from phpmyadmin we didn't use the vbulletin script

        now the emojis appear. sometimes during insertion an invalid sql error (see screenshot) appears especially in chat.
        Click image for larger version  Name:	IMG_20191203_230107.jpg Views:	0 Size:	84.7 KB ID:	4428653

        the emoji inserted before the conversion remained question marks. see the screenshot

        Click image for larger version

Name:	IMG_20191203_235355.jpg
Views:	22
Size:	177.6 KB
ID:	4428654

        instead on the (notice) do not appear totally you see points of question (see the screenshot).

        Click image for larger version  Name:	IMG_20191203_230417.jpg Views:	0 Size:	61.5 KB ID:	4428652
        Last edited by saiff; Tue 3rd Dec '19, 1:59pm.
        https://www.vbulletin.com/forum/foru...re-waiting-for

        Comment


        • #19
          If you didn't convert the existing data using our scripts, then the emoji added before you changed the fields will continue to be broken. We literally have no idea when one character ends and another begins because UTF8 characters can be 1-3 bytes in length. Where UTF8MB4 characters will always be 4 bytes in length.

          Emoji shouldn't be indexed in the word table. I haven't experienced that before. Are you using debug mode? This is vBulletin 5.5.5?
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API - Full / Mobile
          Vote for your favorite feature requests and the bugs you want to see fixed.

          Comment


          • #20
            yes, vbulletin 5.5.5. i am not using debug mode. should i activate it?
            https://www.vbulletin.com/forum/foru...re-waiting-for

            Comment

            Related Topics

            Collapse

            Working...
            X