# \[Bug - FB15746\] MySQL Collation bug in Tree Component

**URL:** <https://forum.inductiveautomation.com/t/bug-fb15746-mysql-collation-bug-in-tree-component/31090>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [January 6, 2020, 6:41pm UTC](https://forum.inductiveautomation.com/t/bug-fb15746-mysql-collation-bug-in-tree-component/31090 "2020-01-06T18:41:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![victor1](https://avatars.discourse-cdn.com/v4/letter/v/6de8d8/32.png) [@victor1](https://forum.inductiveautomation.com/u/victor1)\
**Post date:** [January 6, 2020, 6:41pm UTC](https://forum.inductiveautomation.com/t/bug-fb15746-mysql-collation-bug-in-tree-component/31090/1 "2020-01-06T18:41:22Z")

</div>

Hello!

I have a collation bug when using the tree component.  
The data came from a MySQL database with UTF8 Collation configured.  
When displayed in the Tree component this error occour but when using the Database Query Browser Tool, the text shows perfectly.

![Ignition%20Collation%20bug](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/d06e5274855cbea9649b3406e517872c4bf4261b.png)

Anyone already pass thru that?  
Thanks

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [January 6, 2020, 10:01pm UTC](https://forum.inductiveautomation.com/t/bug-fb15746-mysql-collation-bug-in-tree-component/31090/2 "2020-01-06T22:01:13Z")

</div>

Looks like it’s only happening when nodes are expanded – it’s not happening for São José dos Pinhais. If you can let me know what version of Ignition you’re using I can file a bug report. 😳

---

<div class="post-metadata">

**Author:** ![victor1](https://avatars.discourse-cdn.com/v4/letter/v/6de8d8/32.png) [@victor1](https://forum.inductiveautomation.com/u/victor1)\
**Post date:** [January 7, 2020, 6:51pm UTC](https://forum.inductiveautomation.com/t/bug-fb15746-mysql-collation-bug-in-tree-component/31090/3 "2020-01-07T18:51:30Z")

</div>

I dont know why, but today it is working just fine…  
I think, after the changes I made, it just had to reboot

Thanks for your help!