# Welsh Language character set

**URL:** <https://forums.percona.com/t/welsh-language-character-set/25045>\
**Category:** Percona Server for MySQL\
**Created:** [September 8, 2023, 4:39pm UTC](https://forums.percona.com/t/welsh-language-character-set/25045 "2023-09-08T16:39:55Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![richardb55](https://avatars.discourse-cdn.com/v4/letter/r/ea666f/32.png) [@richardb55](https://forums.percona.com/u/richardb55)\
**Post date:** [September 8, 2023, 4:39pm UTC](https://forums.percona.com/t/welsh-language-character-set/25045/1 "2023-09-08T16:39:55Z")

</div>

I’m looking for a MySQL character set file for the Welsh language, specifically for the purpose of sorting data in the Welsh language.

I’d hoped something would just be out there with someone having had the requirement before but couldn’t find anything.

Does anyone know of anything? or anyone who could create us a MySQL character set?

Richard

---

<div class="post-metadata">

**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:** [September 8, 2023, 5:26pm UTC](https://forums.percona.com/t/welsh-language-character-set/25045/2 "2023-09-08T17:26:20Z")

</div>

Will utf8 or utf16 not work here? For sorting data, you need a collation, not a character set. You can store the data (character set) in raw binary, but to sort, you’d need to use either a binary collation, utf general collation, or language-specific collation.

---

<div class="post-metadata">

**Author:** ![richardb55](https://avatars.discourse-cdn.com/v4/letter/r/ea666f/32.png) [@richardb55](https://forums.percona.com/u/richardb55)\
**Post date:** [September 11, 2023, 7:58am UTC](https://forums.percona.com/t/welsh-language-character-set/25045/3 "2023-09-11T07:58:31Z")

</div>

I skipped some of thinking/research in the question. We do want a language specific collation but user collations are deprecated so we expect to need a character set + collation to do the same thing?

---

<div class="post-metadata">

**Author:** ![richardb55](https://avatars.discourse-cdn.com/v4/letter/r/ea666f/32.png) [@richardb55](https://forums.percona.com/u/richardb55)\
**Post date:** [September 11, 2023, 10:17am UTC](https://forums.percona.com/t/welsh-language-character-set/25045/4 "2023-09-11T10:17:59Z")

</div>

@matthewb - is there a different approach we can take based on that being deprecated?

---

<div class="post-metadata">

**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:** [September 11, 2023, 2:21pm UTC](https://forums.percona.com/t/welsh-language-character-set/25045/5 "2023-09-11T14:21:51Z")

</div>

The best approach is to see if any of the newer character sets and collations introduced in MySQL 8 can handle the language. You may want to open a [bugs.mysql.com](http://bugs.mysql.com) bug and ask them what they officially recommend.

---

<div class="post-metadata">

**Author:** ![richardb55](https://avatars.discourse-cdn.com/v4/letter/r/ea666f/32.png) [@richardb55](https://forums.percona.com/u/richardb55)\
**Post date:** [September 11, 2023, 2:41pm UTC](https://forums.percona.com/t/welsh-language-character-set/25045/6 "2023-09-11T14:41:17Z")

</div>

Nothing in the documentation suggests MySQL has any support for Welsh but I’ll ask the question in that forum like you suggest - thanks.