# Alarm\_table issue

**URL:** <https://forum.inductiveautomation.com/t/alarm-table-issue/8699>\
**Category:** Ignition\
**Created:** [July 10, 2014, 7:05am UTC](https://forum.inductiveautomation.com/t/alarm-table-issue/8699 "2014-07-10T07:05:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Serhii](https://avatars.discourse-cdn.com/v4/letter/s/df788c/32.png) [@Serhii](https://forum.inductiveautomation.com/u/Serhii)\
**Post date:** [July 10, 2014, 7:05am UTC](https://forum.inductiveautomation.com/t/alarm-table-issue/8699/1 "2014-07-10T07:05:12Z")

</div>

Hello!  
Week ago we have database crash.  
After creating new database alert\_log table have some issue:  
1) Column “system” looks like  
[screenshot.su/show.php?img=bc6d4 … 9ed110.jpg](http://screenshot.su/show.php?img=bc6d40be37ce88ef8222fa7a669ed110.jpg)  
but in the MySQL Workbench looks like  
[screenshot.su/show.php?img=002f5 … 64e557.jpg](http://screenshot.su/show.php?img=002f52b6f8202b085d270a635364e557.jpg)  
Difference in “@” and “.” after “SQLTags”.  
2) Maybe, because of p.1 i cant to sort this alarms.  
[screenshot.su/show.php?img=794b2 … 3937af.jpg](http://screenshot.su/show.php?img=794b2d96b747855322910efa303937af.jpg)  
3) When i create new AlarmTag all good, it writes to table when active.  
But tags, created before database crash, don’t want to be writen to the DB.

Help please, it is very important.

---

<div class="post-metadata">

**Author:** ![Serhii](https://avatars.discourse-cdn.com/v4/letter/s/df788c/32.png) [@Serhii](https://forum.inductiveautomation.com/u/Serhii)\
**Post date:** [July 14, 2014, 6:35am UTC](https://forum.inductiveautomation.com/t/alarm-table-issue/8699/2 "2014-07-14T06:35:13Z")

</div>

Any ideas?

---

<div class="post-metadata">

**Author:** ![Serhii](https://avatars.discourse-cdn.com/v4/letter/s/df788c/32.png) [@Serhii](https://forum.inductiveautomation.com/u/Serhii)\
**Post date:** [July 14, 2014, 1:52pm UTC](https://forum.inductiveautomation.com/t/alarm-table-issue/8699/3 "2014-07-14T13:52:57Z")

</div>

When “Name” of alarm in English - 3) point is good. When in Russian - still no detected the alarm.

---

<div class="post-metadata">

**Author:** ![Serhii](https://avatars.discourse-cdn.com/v4/letter/s/df788c/32.png) [@Serhii](https://forum.inductiveautomation.com/u/Serhii)\
**Post date:** [July 14, 2014, 2:35pm UTC](https://forum.inductiveautomation.com/t/alarm-table-issue/8699/4 "2014-07-14T14:35:21Z")

</div>

Okay… All about utf8 - Default collation omg.  
Solved.