mesteele101

How about pulling all the tables in phpmyadmin, and working from that .sql file? Create a new databse, and then import the modified .sql back into the new database?

That's just not an acceptable answer for those of us that were early adopters of IPB 4. You actually want us to loose months of user data. This should have been taken care of when IPB moved from utf8_unicode_ci to utf8mb4_unicode_ci . We trust IPS to do what is right to keep their clients up to date with the latest releases. If the latest releases IPB has had a default character set change there should be a way for IPS's paid clients to benefit from that change, and advancing along with everyone else on the same playing field. It seems to me that IPS should jump ahead of this and create a conversion script for its clients. This not only fixes future problems, but will also lessen support tickets. Or better yet can we create a ticket for this. The majority of independent IPS clients are comfortable with running MySQL scripts.

Woh, maybe so. Looking i Maybe your right? I'm going to start a fresh install and wipe it clean, and see where I'm at. Thanks...

I just checked my live site which was and an upgrade from 3.x, and all the tables are utf8. I just checked my development site as it was a fresh install, and there was a mixture of utf8, and utf8mb4. All tables that start with a ipf_ are utf8, and all the others are utf8mb4. Shouldn't all the tables be utf8mb4 ?

Can you give any information about the conversion> Scripts, location of information?

I don't think there was any or little notice to utf8mb4 until the problem with Emojis was brought up by IPS. I'm thinking that this may be a problem as IPB progresses, and it appears that UTF8MB4 is the standard or what everyone should be striving for. I have little experience with MySQL, so I'm not sure. I see conversion scripts for doing this, but I'm very leery of doing this without the support of IPS. Is UTF8MB4 something we should be looking into?

It's a little disheartening to see developers splitting these seemingly trivial tasks like this into multiple modules, and its not just this developer. It a few years its just going to get crazy keeping up with all these modules. Pinned Topics & Pinned posts I think the developer would get a more favorable response it the above two were in the same module. Just my two cents...