# Collation support for utf8mb4\_0900\_as\_ci **URL:** \ **Category:** ProxySQL\ **Created:** [December 1, 2022, 12:35pm UTC](https://forums.percona.com/t/collation-support-for-utf8mb4-0900-as-ci/18863 "2022-12-01T12:35:21Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Gustavo\_du\_Mortier](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gustavo_du_mortier/32/8519_2.png) [@Gustavo\_du\_Mortier](https://forums.percona.com/u/Gustavo_du_Mortier)\ **Post date:** [December 1, 2022, 12:35pm UTC](https://forums.percona.com/t/collation-support-for-utf8mb4-0900-as-ci/18863/1 "2022-12-01T12:35:21Z")
Does anybody know if ProxySQL supports utf8mb4\_0900\_as\_ci collation? It supports utf8mb4\_0900\_ai\_ci, but I specifically need utf8mb4\_0900\_as\_ci. It is not in the mysql\_collations table. I inserted it in that table with the proper Id and charset but it didn’t work. I’d like to know if it’s possible to add support in ProxySQL for a missing collation. Thanks! ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [December 2, 2022, 8:18am UTC](https://forums.percona.com/t/collation-support-for-utf8mb4-0900-as-ci/18863/2 "2022-12-02T08:18:27Z")
You might want to open a github issue with ProxySQL for this. What error are you seeing when you manually add this collation to proxsql? ---
**Author:** ![Gustavo\_du\_Mortier](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gustavo_du_mortier/32/8519_2.png) [@Gustavo\_du\_Mortier](https://forums.percona.com/u/Gustavo_du_Mortier)\ **Post date:** [December 2, 2022, 11:29am UTC](https://forums.percona.com/t/collation-support-for-utf8mb4-0900-as-ci/18863/3 "2022-12-02T11:29:15Z")
Before manually adding the collation I get this error: Syntax error or access violation: 1115 Unknown character set ‘utf8mb4’ or collation ‘utf8mb4\_0900\_as\_ci’ After adding it to the mysql\_collation table, I still get the same error. Unfortunately, there’s no “load MySQL collations to runtime” command ☹ When I restarted ProxySQL service, the collation I added was gone. So, I guess the mysql\_collation table is not prepared to accept new elements. ---
**Author:** ![Gustavo\_du\_Mortier](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gustavo_du_mortier/32/8519_2.png) [@Gustavo\_du\_Mortier](https://forums.percona.com/u/Gustavo_du_Mortier)\ **Post date:** [December 2, 2022, 11:30am UTC](https://forums.percona.com/t/collation-support-for-utf8mb4-0900-as-ci/18863/4 "2022-12-02T11:30:03Z")
I’ll try opening a GitHub issue for this. Thanks! ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [December 2, 2022, 3:22pm UTC](https://forums.percona.com/t/collation-support-for-utf8mb4-0900-as-ci/18863/5 "2022-12-02T15:22:59Z")
What happens if you connect first, then switch the collation? ``` SET NAMES 'utf8mb4' COLLATE 'utf8mb4_0900_as_ci'; ``` Or set the default in proxysql, mysql-default\_collation\_connection ---
**Author:** ![Gustavo\_du\_Mortier](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gustavo_du_mortier/32/8519_2.png) [@Gustavo\_du\_Mortier](https://forums.percona.com/u/Gustavo_du_Mortier)\ **Post date:** [December 7, 2022, 5:49pm UTC](https://forums.percona.com/t/collation-support-for-utf8mb4-0900-as-ci/18863/6 "2022-12-07T17:49:28Z")
I tried both. When I use the SET NAMES command I get the error Unknown character set ‘utf8mb4’ or collation ‘utf8mb4\_0900\_as\_ci’ Then I looked in the global\_variables table, but there’s no row for mysql-default\_collation\_connection. I tried adding a row with that variable\_name, but it goes away when I execute load MySQL variables to runtime. I guess I have a problem with the ProxySQL Admin, because I first installed ProxySQL 1.x, then installed ProxySQL 2.4 but the admin module is the same as before, and I don’t know how to erase all of the ProxySQL configuration in order to start fresh with version 2.4. ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [December 7, 2022, 8:08pm UTC](https://forums.percona.com/t/collation-support-for-utf8mb4-0900-as-ci/18863/7 "2022-12-07T20:08:50Z")
Stop proxysql. rm -f /var/lib/proxysql/\* Start proxysql 2.4. This will re-init everything. ---
**Author:** ![Gustavo\_du\_Mortier](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gustavo_du_mortier/32/8519_2.png) [@Gustavo\_du\_Mortier](https://forums.percona.com/u/Gustavo_du_Mortier)\ **Post date:** [December 7, 2022, 8:53pm UTC](https://forums.percona.com/t/collation-support-for-utf8mb4-0900-as-ci/18863/8 "2022-12-07T20:53:33Z")
Thank you!! It worked like magic 🙂 ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [December 7, 2022, 9:00pm UTC](https://forums.percona.com/t/collation-support-for-utf8mb4-0900-as-ci/18863/9 "2022-12-07T21:00:46Z")
Just to clarify, all you did was upgrade to ProxySQL 2.4 and your collation now works? Did you have to add it to ProxySQL or did SET NAMES work just fine? ---
**Author:** ![Gustavo\_du\_Mortier](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gustavo_du_mortier/32/8519_2.png) [@Gustavo\_du\_Mortier](https://forums.percona.com/u/Gustavo_du_Mortier)\ **Post date:** [December 7, 2022, 9:21pm UTC](https://forums.percona.com/t/collation-support-for-utf8mb4-0900-as-ci/18863/10 "2022-12-07T21:21:57Z")
> [@matthewb](#): > > set the default in proxysql, mysql-default\_collation\_connection I also had to do this 👆 ---
**Author:** ![Gustavo\_du\_Mortier](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gustavo_du_mortier/32/8519_2.png) [@Gustavo\_du\_Mortier](https://forums.percona.com/u/Gustavo_du_Mortier)\ **Post date:** [December 7, 2022, 9:23pm UTC](https://forums.percona.com/t/collation-support-for-utf8mb4-0900-as-ci/18863/11 "2022-12-07T21:23:36Z")
after restarting everything, this setting: **mysql-default\_collation\_connection** began to show up in the global\_variables table.