# Text encoding in Vision Table

**URL:** <https://forum.inductiveautomation.com/t/text-encoding-in-vision-table/66511>\
**Category:** Ignition\
**Tags:** ignition81, vision\
**Created:** [November 15, 2022, 8:20am UTC](https://forum.inductiveautomation.com/t/text-encoding-in-vision-table/66511 "2022-11-15T08:20:43Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ioannis\_Mamanis](https://avatars.discourse-cdn.com/v4/letter/i/ed8c4c/32.png) [@Ioannis\_Mamanis](https://forum.inductiveautomation.com/u/Ioannis_Mamanis)\
**Post date:** [November 15, 2022, 8:20am UTC](https://forum.inductiveautomation.com/t/text-encoding-in-vision-table/66511/1 "2022-11-15T08:20:43Z")

</div>

Hi all,

i don't know if i am in the correct category but i will give it a shot.

I want to show an Oracle's table data in a Vision Table with DB Browse, i may use a query later.

The problem is that the table has some columns containing greek text ex. Δ-104. Because of that, the Table in Vision shows some unreadable text instead of Δ.

Could someone explain to me what i have to do in order to show the data properly?

Oracle's NLS parameters are:  
NLS\_Lanuage: AMERICAN  
NLS\_Territory: AMERICA  
NLS\_Character\_Set: AL32UTF8

Thanks in advance,  
IM

---

<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 15, 2022, 3:54pm UTC](https://forum.inductiveautomation.com/t/text-encoding-in-vision-table/66511/2 "2022-11-15T15:54:22Z")

</div>

Can you add a screenshot or a description of what the "unreadable" text looks like? That will help diagnose the issue. But to answer your question, everything in any part of Ignition is either UTF-8 or UTF-16.

That said, looks like Greek letters in AL32UTF8 have been a problem for other applications as well. [This](https://community.oracle.com/tech/apps-infra/discussion/3514820/difference-between-al32utf8-and-utf8) may be of help.

---

<div class="post-metadata">

**Author:** ![Ioannis\_Mamanis](https://avatars.discourse-cdn.com/v4/letter/i/ed8c4c/32.png) [@Ioannis\_Mamanis](https://forum.inductiveautomation.com/u/Ioannis_Mamanis)\
**Post date:** [November 21, 2022, 8:51am UTC](https://forum.inductiveautomation.com/t/text-encoding-in-vision-table/66511/3 "2022-11-21T08:51:12Z")

</div>

Hi,  
thank you for your answer and i am sorry for the late reply, i was out of office.

![Screenshot 2022-11-21 103937](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/d/2d8e4c0f02a233740d852ab067bfc034a8a5b051.png)  
 ![Screenshot 2022-11-21 103735](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/6/d63756829e4ecc5af7b21f9bf2e9c03b80ec42cc.png)

As you can see, Ignition can't show the Π symbol from the database.  
I thought that the Oracle NLS encoding configuration at the client side will be enough, so i was thinking if i could set the encoding through Connection Initialization Commands for example, if not the db config is a one way solution.

---

<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 21, 2022, 3:59pm UTC](https://forum.inductiveautomation.com/t/text-encoding-in-vision-table/66511/4 "2022-11-21T15:59:55Z")

</div>

Which version of Oracle are you using? (Note: I'll be out of the office the rest of the week, so if someone else feels like jumping in here...)

---

<div class="post-metadata">

**Author:** ![Ioannis\_Mamanis](https://avatars.discourse-cdn.com/v4/letter/i/ed8c4c/32.png) [@Ioannis\_Mamanis](https://forum.inductiveautomation.com/u/Ioannis_Mamanis)\
**Post date:** [November 21, 2022, 5:25pm UTC](https://forum.inductiveautomation.com/t/text-encoding-in-vision-table/66511/5 "2022-11-21T17:25:39Z")

</div>

It's Oracle 11gr2.

Update: My problem was solved. It was the encoding at Oracle's client side. I changed the client settings and then i updated the problematic data.

Thank you for your time!
