# MySQL Collation

**URL:** <https://ask.gibbonedu.org/t/mysql-collation/3912>\
**Category:** Installation\
**Created:** [December 20, 2022, 12:30am UTC](https://ask.gibbonedu.org/t/mysql-collation/3912 "2022-12-20T00:30:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![cphyan](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/c/dc4da7/32.png) [@cphyan](https://ask.gibbonedu.org/u/cphyan)\
**Post date:** [December 20, 2022, 12:30am UTC](https://ask.gibbonedu.org/t/mysql-collation/3912/1 "2022-12-20T00:30:45Z")

</div>

For my fresh installation of ubuntu 22 and mysql 8.0.31.  
It is requested to have Collation as utf8\_general\_ci, but it is not available…  
Is it okay to use utf8mb4\_general\_ci or utf8mb3\_general\_ci ?  
Best regards

---

<div class="post-metadata">

**Author:** ![sandra](https://ask.gibbonedu.org/user_avatar/ask.gibbonedu.org/sandra/32/5_2.png) [@sandra](https://ask.gibbonedu.org/u/sandra)\
**Post date:** [January 4, 2023, 3:44am UTC](https://ask.gibbonedu.org/t/mysql-collation/3912/2 "2023-01-04T03:44:31Z")

</div>

Hi cphyan, good question, we are looking at changing from utf8\_general\_ci to utf8mb4\_general\_ci, given that the original collation has been deprecated in recent versions of linux. I think if you install with utf8mb4\_general\_ci set it should be okay, I haven’t tested it myself, but I believe MySQL will handle the new collation internally. Please do let me know if you run into any issues using this during installation.

---

<div class="post-metadata">

**Author:** ![cphyan](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/c/dc4da7/32.png) [@cphyan](https://ask.gibbonedu.org/u/cphyan)\
**Post date:** [January 5, 2023, 8:34pm UTC](https://ask.gibbonedu.org/t/mysql-collation/3912/3 "2023-01-05T20:34:24Z")

</div>

Thanks for the clarification Sandra 🙂  
Will let you know if I bump into anything related.