Can someone with MySQL 5.0 or 5.1 run a query for me?

Todd

I'm trying to see whether or not utf8mb4 is even in MySQL 5.0 or 5.1. Can someone that has one of these older databases help me out?

1. Run this query: show variables like 'version'.
2. Run this query: show collation like 'utf8mb4%'.
3. Paste the output of these queries as a comment here.

Thanks!

x00

I think the earliest is 5.5, I can't see it in the 5.1 documentation.

x00

https://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html

x00

I think a min of 5.5.3 or 5.6 to be on the safe side.

x00

I would consider detection as a version of ubuntu didn't have it included by default.

Todd

Yeah I read those docs and they say:

As of MySQL 5.5.3, the utf8mb4 character set uses a maximum of four bytes per character supports supplemental characters

To me that could mean that utf8mb4 exists earlier, but doesn't use a maximum of four bytes. If the encoding and associated collations exist earlier, but are just maybe an alias of utf8 then that would be workable, but I might be just holding out hope.

x00

It seems unlikely that it would be in 5.1 as standard.

Anonymoose

mysql> show variables like 'version';
+---------------+----------+
| Variable_name | Value    |
+---------------+----------+
| version       | 5.1.73-1 |
+---------------+----------+
1 row in set (0.00 sec)

mysql> show collation like 'utf8mb4%';
Empty set (0.02 sec)

mysql>

Todd

Thanks @Anonymoose!