# Alarm name special char

**URL:** <https://forum.inductiveautomation.com/t/alarm-name-special-char/47826>\
**Category:** Ignition\
**Tags:** ignition80, scripting\
**Created:** [June 16, 2021, 1:16pm UTC](https://forum.inductiveautomation.com/t/alarm-name-special-char/47826 "2021-06-16T13:16:43Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\
**Post date:** [June 16, 2021, 1:16pm UTC](https://forum.inductiveautomation.com/t/alarm-name-special-char/47826/1 "2021-06-16T13:16:43Z")

</div>

Hi

I store a tag JSON config in my MySQL DB. When I get it in a script and use system.util.jsonDecode() I have some trouble in my alarm name.

My tag JSON stored in DB :

```auto
"name": "Conso réelle supérieure à l'attendue (3j cumulés)"

```

The same alarm name in my created tag :  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/4/f400b0530e982289506f80fddbae1addcd78e7bb.png)

Thanks for your help

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [June 16, 2021, 1:59pm UTC](https://forum.inductiveautomation.com/t/alarm-name-special-char/47826/2 "2021-06-16T13:59:04Z")

</div>

Try:

```auto
"name": u"Conso réelle supérieure à l'attendue (3j cumulés)"

```

---

<div class="post-metadata">

**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\
**Post date:** [June 16, 2021, 2:13pm UTC](https://forum.inductiveautomation.com/t/alarm-name-special-char/47826/3 "2021-06-16T14:13:53Z")

</div>

I can’t do that because I get my tag json config from my DB. So alarm\_name is stored in a variable.

```auto
tagCnf = system.db.runScalarQuery("SELECT jsonConfig FROM alarms WHERE id = 1")
tagCnf = system.util.jsonDecode(tagCnf)
system.tag.configure(baseTagPath,[tagCnf],"o")

```

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [June 16, 2021, 3:17pm UTC](https://forum.inductiveautomation.com/t/alarm-name-special-char/47826/4 "2021-06-16T15:17:44Z")

</div>

Does your database column that stores your json have a unicode compatible encoding set up? Like UTF-8?

---

<div class="post-metadata">

**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\
**Post date:** [June 17, 2021, 7:26am UTC](https://forum.inductiveautomation.com/t/alarm-name-special-char/47826/5 "2021-06-17T07:26:34Z")

</div>

My table config below :

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/a/5a1e32f40925d6877f0d63ef9a10f20fc8678be7.png)  
When I want to change “config” encoding in utf8\_general\_ci, it shows me message below.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/1/81fb6581761a61b30484349c6c14129399d098be.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [June 17, 2021, 12:46pm UTC](https://forum.inductiveautomation.com/t/alarm-name-special-char/47826/6 "2021-06-17T12:46:04Z")

</div>

You’ll have to look in MySQL docs how to deal with that. You may even have to re-create the DB with option for another character set, IIRC.

Maybe someone else here who likes MySQL will chime in.

---

<div class="post-metadata">

**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\
**Post date:** [January 27, 2022, 11:34am UTC](https://forum.inductiveautomation.com/t/alarm-name-special-char/47826/7 "2022-01-27T11:34:20Z")

</div>

It works when using `SELECT CONVERT(jsonConfig USING utf8)` in your query.  
It works too for INSERT and UPDATE statements.