# Issues with Spanish special characters

**URL:** <https://forum.inductiveautomation.com/t/issues-with-spanish-special-characters/71532>\
**Category:** Ignition\
**Created:** [March 24, 2023, 8:40am UTC](https://forum.inductiveautomation.com/t/issues-with-spanish-special-characters/71532 "2023-03-24T08:40:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![lachguerabdallah](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lachguerabdallah/32/25558_2.png) [@lachguerabdallah](https://forum.inductiveautomation.com/u/lachguerabdallah)\
**Post date:** [March 24, 2023, 8:40am UTC](https://forum.inductiveautomation.com/t/issues-with-spanish-special-characters/71532/1 "2023-03-24T08:40:11Z")

</div>

Hello,

I have some problems with the readBlocking function.

I have a script where I read the tooltip from a tag, the tooltip has the Spanish character 'ñ'.

when using the readBlocking function. the result is as expected. the text displays fine.

but when reading only the value. the text is no longer displayed correctly.

To explain better, I put a screenshot of my code.  
as shown, I add the qualified value to the list, then add just the value.  
the qualified value is displayed fine but the value is not.

[![](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/5/65d0f2580750dfb51d667aff6f83f2be8d7bbcde.png) ](https://p13.zdusercontent.com/attachment/10006614/RtjWJHDQz7aYdTQHGrmXdhpzQ?token=eyJhbGciOiJkaXIiLCJlbmMiOiJBMTI4Q0JDLUhTMjU2In0..bH8BprMJyLCRrnKuDEUTKA.8HC5-gzNmbJI_Te6eM4kclD4RejmU6cFoejuf-q8DUhHi1rHjH3-sGgenK5uJdK4d5ULO0yAFk-4Qu39dZZaMYvr-X2F1NQs2ayYk6-UfQps3AaIWvMYzffNAOQHMUfQ6Opssf_naWjq7Yc9tRf7ekTm_A4wu-C2RD66-FII-Wz0sfQWTcfK96iE7rFVlPBDJmxd-FBDRIMNyiDMYb16RqqpKaro70L6Sfvr--p8F6Yrsp8qsZla6hz3wbV7KJmwErpCESjxATC69_kaYEp1YHt97hXKBWOQ6WesJY0Kcw8.1eV8NEm8jaU1pJ7F6ON0BA)

---

<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 24, 2023, 11:44am UTC](https://forum.inductiveautomation.com/t/issues-with-spanish-special-characters/71532/2 "2023-03-24T11:44:40Z")

</div>

It isn't wrong. You are seeing the `repr()` form instead of the `unicode()` form from jython's object print. It is a side-effect of print. Are you actually seeing the wrong character when that value is assigned to a component property?

---

<div class="post-metadata">

**Author:** ![lachguerabdallah](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lachguerabdallah/32/25558_2.png) [@lachguerabdallah](https://forum.inductiveautomation.com/u/lachguerabdallah)\
**Post date:** [March 24, 2023, 2:11pm UTC](https://forum.inductiveautomation.com/t/issues-with-spanish-special-characters/71532/3 "2023-03-24T14:11:24Z")

</div>

when I assign the value to a property of a component it looks good but when I insert values into a database table they get inserted wrong.

---

<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 24, 2023, 2:35pm UTC](https://forum.inductiveautomation.com/t/issues-with-spanish-special-characters/71532/4 "2023-03-24T14:35:44Z")

</div>

That usually means the database hasn't been configured for unicode correctly. Assuming you are passing the strings to the DB via named query value parameters or via scripted "Prep" DB calls with question mark parameters.

However, if you are using curly braces to inject strings into a query, then it is unfixable. If you are assembling a scripted query with string substitution, it probably isn't fixable either.

---

<div class="post-metadata">

**Author:** ![lachguerabdallah](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lachguerabdallah/32/25558_2.png) [@lachguerabdallah](https://forum.inductiveautomation.com/u/lachguerabdallah)\
**Post date:** [March 24, 2023, 3:09pm UTC](https://forum.inductiveautomation.com/t/issues-with-spanish-special-characters/71532/5 "2023-03-24T15:09:55Z")

</div>

the database was set to unicode, and to insert the data it used a Named Query, I just used.

I am now using runPrepQuery and the data is inserted correctly.  
thank you