# Non-english characters -\> wierd characters

**URL:** <https://forum.inductiveautomation.com/t/non-english-characters-wierd-characters/12012>\
**Category:** General Discussion\
**Created:** [August 8, 2016, 1:28pm UTC](https://forum.inductiveautomation.com/t/non-english-characters-wierd-characters/12012 "2016-08-08T13:28:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![StefanGronberg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/stefangronberg/32/6288_2.png) [@StefanGronberg](https://forum.inductiveautomation.com/u/StefanGronberg)\
**Post date:** [August 8, 2016, 1:28pm UTC](https://forum.inductiveautomation.com/t/non-english-characters-wierd-characters/12012/1 "2016-08-08T13:28:04Z")

</div>

Hi, when a client is using swedish ÅÄÖ for example, the text is stored as åäö in the database.  
In some components, they are shown correctly, but in a few places they get replaced with 2 wierd characters.

How to get this behaviour to stop?

[attachment=0]locale\_n.png[/attachment]

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [August 8, 2016, 2:55pm UTC](https://forum.inductiveautomation.com/t/non-english-characters-wierd-characters/12012/2 "2016-08-08T14:55:18Z")

</div>

The system.db.runPrepUpdate function is working fine with ÅÄÖ in my tests. Since I see a table called EditRecipe, I’m going to assume you’re working with a MES component, which I can’t test. If you can email your issue to support, they can open a ticket with the MES group and get that fixed for you.

In the mean time, hopefully another forum user will have a workaround for you…

---

<div class="post-metadata">

**Author:** ![StefanGronberg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/stefangronberg/32/6288_2.png) [@StefanGronberg](https://forum.inductiveautomation.com/u/StefanGronberg)\
**Post date:** [August 9, 2016, 5:15am UTC](https://forum.inductiveautomation.com/t/non-english-characters-wierd-characters/12012/3 "2016-08-09T05:15:31Z")

</div>

[quote=“KathyApplebaum”]The system.db.runPrepUpdate function is working fine with ÅÄÖ in my tests. Since I see a table called EditRecipe, I’m going to assume you’re working with a MES component, which I can’t test. If you can email your issue to support, they can open a ticket with the MES group and get that fixed for you.

In the mean time, hopefully another forum user will have a workaround for you…[/quote]

Hi, we are not using MES-component in this case. and the åäö seems to work a bit randomly. So there must be some encoding option somewhere that throws out the åäö and tosses in 2 random looking characters instead.

---

<div class="post-metadata">

**Author:** ![AlThePal](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/althepal/32/3603_2.png) [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\
**Post date:** [September 13, 2016, 6:57pm UTC](https://forum.inductiveautomation.com/t/non-english-characters-wierd-characters/12012/4 "2016-09-13T18:57:28Z")

</div>

Can you show us the code you use to create the list of values? Are you forcing any of these strings into Unicode?