Forum Discussion

sivech3333's avatar
sivech3333
New Contributor
3 years ago

All the showing as u0000 for a Jsonfile

Hi team, I am trying to get a Json file from Database using a query. But the retruned variable is as below.  "\"\\u0000\\u0000\\u0000\\u0000\\u0010\\u0000\\u0000\\u0000ߧ\\u0005\\u0011\\t\\f\\u001e꾀...
rraghvani's avatar
rraghvani
Icon for Champion Level 3 rankChampion Level 3
3 years ago

In this example, I have the following data setup in MS SQL Server

And I'm using MSOLEDBSQL19.1 as the Provider in my connection string. The output is correctly shown

Ensure you are using the correct Provider for your connection string.