# Special character issues - Url link update in dashboard and database - Postgresql

**URL:** https://discourse.nodered.org/t/special-character-issues-url-link-update-in-dashboard-and-database-postgresql/61532
**Category:** Dashboard
**Tags:** node-red-dashboard, database
**Created:** [20 April 2022 09:20 UTC](https://discourse.nodered.org/t/special-character-issues-url-link-update-in-dashboard-and-database-postgresql/61532 "2022-04-20T09:20:10Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![learnobyte](https://avatars.discourse-cdn.com/v4/letter/l/d6d6ee/32.png) [@learnobyte](https://discourse.nodered.org/u/learnobyte)
#### Post date: [20 April 2022 09:20 UTC](https://discourse.nodered.org/t/special-character-issues-url-link-update-in-dashboard-and-database-postgresql/61532/1 "2022-04-20T09:20:10Z")

</div>

hi all, i am updating the url link in database through ui-text input node and postgresql, displaying ui-table.

example: [http://localhost:3000/d/oJ65LywGk/dashboard-oee-1?orgId=1](http://localhost:3000/d/oJ65LywGk/dashboard-oee-1?orgId=1) this is the url, after updating, in the ui-table and database, it shows like below:  
Where it is not accepting special characters.

SQL Query: INSERT INTO grafana\_list (machine\_name,machine\_no,link,note) VALUES ('{{msg.payload.machine\_name}}','{{msg.payload.machine\_no}}','{{msg.payload.link}}','{{msg.payload.note}}');

[http://localhost:3000/d/oJ65LywGk/dashboard-oee-1?orgId=1](http://localhost:3000/d/oJ65LywGk/dashboard-oee-1?orgId=1)

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/a/0a15de4e5759f21985d09bfd0a92d864009cb4d3.png)

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/b/0bfd6f3efbd950080f555f57440d6a2e4629f5cf.png)

requesting to support

---

<div class="post-metadata">

### Author: ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)
#### Post date: [20 April 2022 15:26 UTC](https://discourse.nodered.org/t/special-character-issues-url-link-update-in-dashboard-and-database-postgresql/61532/2 "2022-04-20T15:26:36Z")

</div>

> [@learnobyte](#):
>
> {{msg.payload.machine\_name}}

use triple braces  
`{{{msg.payload.machine_name}}}`  
Then it will not convert html/special characters

---

<div class="post-metadata">

### Author: ![learnobyte](https://avatars.discourse-cdn.com/v4/letter/l/d6d6ee/32.png) [@learnobyte](https://discourse.nodered.org/u/learnobyte)
#### Post date: [21 April 2022 04:01 UTC](https://discourse.nodered.org/t/special-character-issues-url-link-update-in-dashboard-and-database-postgresql/61532/3 "2022-04-21T04:01:19Z")

</div>

Thanks @E1cid , it is updating correctly., why three curly brackets are using?

---

<div class="post-metadata">

### Author: ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)
#### Post date: [21 April 2022 06:11 UTC](https://discourse.nodered.org/t/special-character-issues-url-link-update-in-dashboard-and-database-postgresql/61532/4 "2022-04-21T06:11:05Z")

</div>

If you read the help info for the node in the sidebar it explains that 3 braces tell the node not to replace html/special characters. Why, because that's how the node author configured it, probably so you can display the text on a web page, where the characters would cause issues.

---

<div class="post-metadata">

### Author: ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)
#### Post date: [21 April 2022 07:35 UTC](https://discourse.nodered.org/t/special-character-issues-url-link-update-in-dashboard-and-database-postgresql/61532/5 "2022-04-21T07:35:44Z")

</div>

It’s a “feature” of the mustache syntax library being used. See the mustache docs for details [GitHub - janl/mustache.js: Minimal templating with {{mustaches}} in JavaScript](https://github.com/janl/mustache.js)

---

<div class="post-metadata">

### Author: ![learnobyte](https://avatars.discourse-cdn.com/v4/letter/l/d6d6ee/32.png) [@learnobyte](https://discourse.nodered.org/u/learnobyte)
#### Post date: [21 April 2022 14:05 UTC](https://discourse.nodered.org/t/special-character-issues-url-link-update-in-dashboard-and-database-postgresql/61532/6 "2022-04-21T14:05:33Z")

</div>

Thanks @E1cid

---

<div class="post-metadata">

### Author: ![learnobyte](https://avatars.discourse-cdn.com/v4/letter/l/d6d6ee/32.png) [@learnobyte](https://discourse.nodered.org/u/learnobyte)
#### Post date: [21 April 2022 14:05 UTC](https://discourse.nodered.org/t/special-character-issues-url-link-update-in-dashboard-and-database-postgresql/61532/7 "2022-04-21T14:05:48Z")

</div>

Thanks @dceejay

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)
#### Post date: [5 May 2022 14:06 UTC](https://discourse.nodered.org/t/special-character-issues-url-link-update-in-dashboard-and-database-postgresql/61532/8 "2022-05-05T14:06:10Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.
