XF 2.0 Converting to utf8mb4?

Fred.

Well-known member
Hi,

Where do I find information to convert my DB to utf8mb4?
My tables are still utf8_general_ci after the upgrade from XF 1.5 to 2.0 beta1

Thanks :)
 

Kirby

Well-known member
Are there any known showstoppers (except for the obvious things like username conflicts) for using utf8mb4_unicode_ci?
 

Mike

XenForo developer
Staff member
No, we used it for a while before discovering incompatibilities with the conversion.
 

Rudy

Well-known member
I'm prepping for a possible 2.0/2.1 upgrade.

Which fields does conversion act on? I really would want it to apply only to the text in posts, conversations and profile posts (not in titles or anywhere else--we have too many members who might abuse it).

Is the code easy enough to modify so I could avoid converting what I don't want converted? (Or at least, let me know which directory it is in, so I can take a peek.) And, are there any issues to worry about re: ElasticSearch?
 

Chris D

XenForo developer
Staff member
Unfortunately, we don't have any concept of selective conversion. So it's either all or nothing.
 

Rudy

Well-known member
Interesting. I figured since database tables had to be altered, that it might have been possible to eliminate those we didn't want to convert.

Thanks for the info!
 

Chris D

XenForo developer
Staff member
Even if it was possible to only convert selected tables or fields, our input filtering works on all input so it wouldn't be possible to prevent utf8mb4 going into fields that didn't support it, and that would generate invalid string errors.
 
Top