# Insert euro symbol in database from ignition

**URL:** <https://forum.inductiveautomation.com/t/insert-euro-symbol-in-database-from-ignition/71450>\
**Category:** Ignition\
**Tags:** vision, ignition81\
**Created:** [March 22, 2023, 5:42pm UTC](https://forum.inductiveautomation.com/t/insert-euro-symbol-in-database-from-ignition/71450 "2023-03-22T17:42:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Priyanka.Khandge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/priyanka.khandge/32/35989_2.png) [@Priyanka.Khandge](https://forum.inductiveautomation.com/u/Priyanka.Khandge)\
**Post date:** [March 22, 2023, 5:42pm UTC](https://forum.inductiveautomation.com/t/insert-euro-symbol-in-database-from-ignition/71450/1 "2023-03-22T17:42:44Z")

</div>

Hi guys,

I have tried to insert the euro(€) symbol in the database using the insert query from the vision button action performed but the format is not ok in the database.

val = str(202) + str("€")

Display the database in this format:

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/2/a2b90a36493e8caa7812bd0cc5578b4ecb025ccb.png)

Database = SQL Server  
Ignition = 8.1.17

when I directly insert it from the SQL server then worked perfectly. but When I tried to insert it from the ignition then not ok.

Any idea how to fix this?

Thanks,  
Priyanka

---

<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:** [March 22, 2023, 5:45pm UTC](https://forum.inductiveautomation.com/t/insert-euro-symbol-in-database-from-ignition/71450/2 "2023-03-22T17:45:43Z")

</div>

don't use `str()`. That is not unicode-friendly. Use the `u''` marker for jython string constants that need unicode treatment. So:

```auto
val = str(202) + u'€'

```

---

<div class="post-metadata">

**Author:** ![Priyanka.Khandge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/priyanka.khandge/32/35989_2.png) [@Priyanka.Khandge](https://forum.inductiveautomation.com/u/Priyanka.Khandge)\
**Post date:** [March 22, 2023, 5:51pm UTC](https://forum.inductiveautomation.com/t/insert-euro-symbol-in-database-from-ignition/71450/3 "2023-03-22T17:51:43Z")

</div>

@pturmel Thank you so much for your quick response.

Worked perfectly!!