# runPrepUpdate with ciryllic caraters

**URL:** <https://forum.inductiveautomation.com/t/runprepupdate-with-ciryllic-caraters/7248>\
**Category:** Ignition\
**Created:** [September 12, 2013, 12:16pm UTC](https://forum.inductiveautomation.com/t/runprepupdate-with-ciryllic-caraters/7248 "2013-09-12T12:16:51Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![2Gi\_Technologie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/2gi_technologie/32/3307_2.png) [@2Gi\_Technologie](https://forum.inductiveautomation.com/u/2Gi_Technologie)\
**Post date:** [September 12, 2013, 12:16pm UTC](https://forum.inductiveautomation.com/t/runprepupdate-with-ciryllic-caraters/7248/1 "2013-09-12T12:16:51Z")

</div>

Hello,  
When I make this request, I have that ‘???’ in the database MySql

```auto
system.db.runPrepUpdate("INSERT INTO translate (e,r) VALUES (?,?)",['AIR','воздух'])
```

Any idea ? thanks.

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [September 12, 2013, 6:12pm UTC](https://forum.inductiveautomation.com/t/runprepupdate-with-ciryllic-caraters/7248/2 "2013-09-12T18:12:32Z")

</div>

Ok, we are tracking this here and I am showing that this has been fixed for Ignition version 7.6.4

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [September 12, 2013, 6:14pm UTC](https://forum.inductiveautomation.com/t/runprepupdate-with-ciryllic-caraters/7248/3 "2013-09-12T18:14:07Z")

</div>

In addition to the fix on our end, I think you’re also going to need to use python’s unicode string syntax:

```auto
system.db.runPrepUpdate("INSERT INTO translate (e,r) VALUES (?,?)",['AIR',u'воздух'])
```

Note the ‘u’ before the quotes for the string containing unicode characters. You might try this out on the current release just in case that’s all that was needed.

---

<div class="post-metadata">

**Author:** ![2Gi\_Technologie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/2gi_technologie/32/3307_2.png) [@2Gi\_Technologie](https://forum.inductiveautomation.com/u/2Gi_Technologie)\
**Post date:** [September 12, 2013, 6:24pm UTC](https://forum.inductiveautomation.com/t/runprepupdate-with-ciryllic-caraters/7248/4 "2013-09-12T18:24:57Z")

</div>

I had already tried with the ‘u’, the problem is the same.  
I use 7.5.10 lts. correction also applies to this version?

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [September 25, 2013, 3:57pm UTC](https://forum.inductiveautomation.com/t/runprepupdate-with-ciryllic-caraters/7248/5 "2013-09-25T15:57:57Z")

</div>

Yes, this will be back ported to 7.5

---

<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:** [October 26, 2013, 12:10am UTC](https://forum.inductiveautomation.com/t/runprepupdate-with-ciryllic-caraters/7248/6 "2013-10-26T00:10:29Z")

</div>

We’re still working on the issue. Some parts are fixed, some aren’t.

Fixed in 7.5.11 and 7.6.4:  
[ul][li]\* Binding unicode to component properties[/li][li]\* Unicode output in message boxes[/li][li]\* Unicode output to console in Linux[/li][/ul]

Still working on:  
[ul][li]\* runPrepUpdate[/li][li]\* output to console in Windows[/li][/ul]

---

<div class="post-metadata">

**Author:** ![2Gi\_Technologie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/2gi_technologie/32/3307_2.png) [@2Gi\_Technologie](https://forum.inductiveautomation.com/u/2Gi_Technologie)\
**Post date:** [October 26, 2013, 5:10pm UTC](https://forum.inductiveautomation.com/t/runprepupdate-with-ciryllic-caraters/7248/7 "2013-10-26T17:10:48Z")

</div>

Great thanks !

---

<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:** [November 8, 2013, 2:01am UTC](https://forum.inductiveautomation.com/t/runprepupdate-with-ciryllic-caraters/7248/8 "2013-11-08T02:01:13Z")

</div>

In MySQL, runPrepUpdate works with non-Latin characters. You just need to fix your connection URL.

Go to the Gateway, and under Configure -\> Databases -\> Connections -\> Connection URL add `?useUnicode=yes&characterEncoding=UTF-8` to the end of your connection URL

---

<div class="post-metadata">

**Author:** ![2Gi\_Technologie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/2gi_technologie/32/3307_2.png) [@2Gi\_Technologie](https://forum.inductiveautomation.com/u/2Gi_Technologie)\
**Post date:** [November 26, 2013, 6:22pm UTC](https://forum.inductiveautomation.com/t/runprepupdate-with-ciryllic-caraters/7248/9 "2013-11-26T18:22:38Z")

</div>

Hi,  
It work in 7.5 and with URL connection modified.  
Perfect !  
Thanks.