# Ignition sql tag result is different from SQL server side

**URL:** <https://forum.inductiveautomation.com/t/ignition-sql-tag-result-is-different-from-sql-server-side/34746>\
**Category:** Ignition\
**Tags:** database\
**Created:** [May 14, 2020, 2:35pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-tag-result-is-different-from-sql-server-side/34746 "2020-05-14T14:35:36Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![yifeiliu08](https://avatars.discourse-cdn.com/v4/letter/y/bbe5ce/32.png) [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\
**Post date:** [May 14, 2020, 2:35pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-tag-result-is-different-from-sql-server-side/34746/1 "2020-05-14T14:35:36Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/fb32babfa42440d03255475101f94fc29b26d5a5.png)  
i do the sql query in the server side,  
i can see the result is  
‘0x9BBE97A19BBDA4929BBDFE969BBDA7F79BBFFE9A35303030313533363430209BBDF7919BBDA7F79BBFFE9A3136473031303334350A9BBDE4E99BBE9AC49BBDFE969BBDF0819BBFFE9A46343939303130303638209BBDE4E99BBDA9C19BBFFE9A9BBEBDD19BBE84F24E549BBDC4F69BBDC4CB9BBDBCA62020200A9BBDF0DB9BBDBDA69BBFFE9A33312E36329BBDF8F320209BBDCAF09BBEA3CF9BBFFE9A319BBDCEE12041544F3A54585A3138383239360A9BBDF7B19BBDB2B49BBDA4B69BBEA0A00A20202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020’

i can use python decode(‘hex’) make it works

but i found if i use sql tag , the result is not the same

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/c02e9fb77c1f73ba003f54d4c65f9b8f0f178e7f.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/39570bedac4ba5cffb05f29b7db97be5ad92b18e.png)

why my sql tag is totally different from the result in the sql side?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [May 14, 2020, 3:15pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-tag-result-is-different-from-sql-server-side/34746/2 "2020-05-14T15:15:34Z")

</div>

What’s the actual data type of the column you’re returning?  
It looks like the JDBC driver or Ignition is automatically coercing it into a different, string-based encoding.

---

<div class="post-metadata">

**Author:** ![yifeiliu08](https://avatars.discourse-cdn.com/v4/letter/y/bbe5ce/32.png) [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\
**Post date:** [May 15, 2020, 3:16am UTC](https://forum.inductiveautomation.com/t/ignition-sql-tag-result-is-different-from-sql-server-side/34746/3 "2020-05-15T03:16:41Z")

</div>

your guess is right, if i set the query tag is string or text , it is what my picture shows  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/bee80cdc4a527090fbfde5a0a359a776fffaa485.png)  
after i check my SQL server side, i found the DataType is binary

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/2da6eb44599386f713cc423c20f1c3ce5e6e50e8.png)  
but if i set the tag to Binary Data, it shows connect bad.  
how to make the query result the same as what i have done in the sql server side?

---

<div class="post-metadata">

**Author:** ![Sanderd17](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sanderd17/32/8735_2.png) [@Sanderd17](https://forum.inductiveautomation.com/u/Sanderd17)\
**Post date:** [May 15, 2020, 6:32am UTC](https://forum.inductiveautomation.com/t/ignition-sql-tag-result-is-different-from-sql-server-side/34746/4 "2020-05-15T06:32:10Z")

</div>

It looks like returning base64 to me. Can you check what you get when you execute the following code on the returned string in Ignition?

```auto
import base64
base64.b64decode(text)

```

---

<div class="post-metadata">

**Author:** ![yifeiliu08](https://avatars.discourse-cdn.com/v4/letter/y/bbe5ce/32.png) [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\
**Post date:** [May 15, 2020, 9:31am UTC](https://forum.inductiveautomation.com/t/ignition-sql-tag-result-is-different-from-sql-server-side/34746/5 "2020-05-15T09:31:19Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/8ee6f52be0cf52680be66cb652efde305c509a08.png)  
it works thanks a lot