XF 2.0 Converting to utf8mb4?

[Fred.]

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

 

[Chris D]

They will be, the conversion is not automatic.

It needs to be run from the command line:

php cmd.php xf:convert-utf8mb4

 

[Fred.]

They will be, the conversion is not automatic.

It needs to be run from the command line:

php cmd.php xf:convert-utf8mb4

Thanks Chris, that was what I needed.
I also just found php cmd.php xf:list A list with all the options.

 

[duderuud]

Just remember the conversion can take a long time if you have a lot of posts.

 

[Kirby]

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

 

[Mike]

No, we used it for a while before discovering incompatibilities with the conversion.

 

[Wildcat Media]

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]

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

 

[Wildcat Media]

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]

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.

 

[Wildcat Media]

Makes sense!

 

[rosal]

I have 1.5.24 with utf8_general_ci so i need to update to utf8mb4 before upgrade to xenforo 2 or after?

About this commad
php cmd.php xf:convert-utf8mb4

where is to run in phpmyadmin or ssh?

 

[Paul B]

You run the command after upgrading to XF2.

It is run via SSH.

Emoji support | Manual | XenForo

End-user documentation for XenForo

xenforo.com