Setting the right character set with MAMP ... !?

RedFox · 2016-11-15 08:36:26

I’m getting an error with moving a local database (MAMP) to a server of a specific ISP. It says there’s an “Unknown character set ‘utf8mb4’” on line 17 > screendump

In the database dump on line 17 it says: “/*!40101 SET NAMES utf8mb4_unicode_ci */;” … it’s the default setting in MAMP PRO (4.6.0) of “Server connection collation” in phpMyAdmin > screendump

If I make it “utf8_unicode_ci” or “utf8” by hand the error disappears. If I want to make it the default in MAMP it turns again into “utf8mb4_unicode_ci” … !?

My question is: what do you do with the default settings in MAMP (if you use MAMP at all)? What’s are the best settings to work with?

BTW … if this error occurs the Txp setup becomes a mess. No sections, not all of the plugins and all kind of other database related problems.

Last edited by RedFox (2016-11-15 08:51:31)

bici · 2016-11-16 03:46:36

ditto for me

bici · 2017-03-07 05:08:35

BUMP

About to start another website and i am deploying first on MAMP.

which setting should we use for UTF ?? utf8mb4_unicode_ci or utf8_unicode_ci

jakob · 2017-03-07 07:24:43

bici, to decide you need to check the remote server where you are going to install the website eventually and find out which version of mySQL you have, for example by calling up phpmyadmin or using a phpinfo file. If your remote server has MySQL version 5.5.3 or greater, you can use utf8mb4, if lower you should use utf8.

MAMP should work fine with either (it does on my computer). The problem only arises when transferring to an online server with an older version of mysql.

The multibyte/4-byte version of utf8 was only introduced then and covers a larger set of characters than the regular (already vast) utf8 charset. If you’re worried and don’t know, I would go with utf8 unless you are working in a specific language that requires the larger charset.

bici · 2017-03-07 16:18:56

Thank you jakob, that is the best explanation i have seen. basically i am going to stay with utf8

RedFox · 2017-03-07 16:27:13

Jacob … thanks … :)

michaelkpate · 2017-03-07 16:37:37

jakob wrote #304478:

If your remote server has MySQL version 5.5.3 or greater, you can use utf8mb4, if lower you should use utf8.

PHP version: 5.6.29
MySQL: 5.6.25-log

I was reinstalling Textpattern on CMS Styles last night (starting fresh) and I just happened to compare the config.php from 2014 to the new one. The only change was the utf8mb4 part. I didn’t understand what that meant but now I do.

Thanks, Jakob

bici · 2017-03-07 18:55:54

michaelkpate wrote #304490:

Textpattern on CMS Styles

Chicago Manual of Style?

what is CMS Styles

michaelkpate · 2017-03-07 22:41:02

bici wrote #304492:

what is CMS Styles

The blog I link to in my signature. :) Originally it was about theming for content management systems and then later evolved into more of a Textpattern focused site. Which got wiped out during the Textdrive implosion. I still plan to bring it back at some point when I figure out what I want to use it for.

Textpattern CMS

Textpattern CMS support forum

#1 2016-11-15 08:36:26