# Escape character for SQL module

**URL:** https://discuss.elastic.co/t/escape-character-for-sql-module/248352
**Category:** Beats
**Tags:** metricbeat
**Created:** [September 11, 2020, 3:33pm UTC](https://discuss.elastic.co/t/escape-character-for-sql-module/248352 "2020-09-11T15:33:04Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Prashant\_Achari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prashant_achari/32/49232_2.png) [@Prashant\_Achari](https://discuss.elastic.co/u/Prashant_Achari)
#### Post date: [September 11, 2020, 3:33pm UTC](https://discuss.elastic.co/t/escape-character-for-sql-module/248352/1 "2020-09-11T15:33:04Z")

</div>

I am using SQL module and user password has "#". I gave "" prior to hash but the same is not working. Can you pl help

error :oracle://GTXXX:July": invalid port ":July" after host

---

<div class="post-metadata">

### Author: ![Prashant\_Achari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prashant_achari/32/49232_2.png) [@Prashant\_Achari](https://discuss.elastic.co/u/Prashant_Achari)
#### Post date: [September 11, 2020, 3:54pm UTC](https://discuss.elastic.co/t/escape-character-for-sql-module/248352/2 "2020-09-11T15:54:01Z")

</div>

hosts: ["oracle://Elastic:July#2020@myoracledb.com:1521/test\_any?sslmode=disable"]

---

<div class="post-metadata">

### Author: ![shaunak](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shaunak/32/6643_2.png) [@shaunak](https://discuss.elastic.co/u/shaunak)
#### Post date: [September 14, 2020, 1:44pm UTC](https://discuss.elastic.co/t/escape-character-for-sql-module/248352/3 "2020-09-14T13:44:40Z")

</div>

Could you try using either `\#` or `%23` in place of the `#`?

---

<div class="post-metadata">

### Author: ![Prashant\_Achari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prashant_achari/32/49232_2.png) [@Prashant\_Achari](https://discuss.elastic.co/u/Prashant_Achari)
#### Post date: [September 14, 2020, 1:46pm UTC](https://discuss.elastic.co/t/escape-character-for-sql-module/248352/4 "2020-09-14T13:46:58Z")

</div>

I tried \ but gave same error will try with %23

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 12, 2020, 3:47pm UTC](https://discuss.elastic.co/t/escape-character-for-sql-module/248352/5 "2020-10-12T15:47:01Z")

</div>

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