HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

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

ToddTodd Chief Product Officer Vanilla Staff

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!

Tagged:

Comments

  • x00x00 MVP
    edited May 2015

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

    grep is your friend.

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

    grep is your friend.

  • x00x00 MVP
    edited May 2015

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

    grep is your friend.

  • ToddTodd Chief Product Officer Vanilla Staff

    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.

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

    grep is your friend.

  • AnonymooseAnonymoose ✭✭
    edited May 2015
    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>
    
  • ToddTodd Chief Product Officer Vanilla Staff

    Thanks @Anonymoose!

Sign In or Register to comment.