Hi Alberto
I am using your SSIS-Json-Source-Component
And I came across a problem with a Json field inside the Json File
My problem is that I have Hebrew text in the value (in the inner Json field)
And when I try to import the field to my DB (Oracle) I am getting questions marks instead
If there are Hebrew letters in other fields (on the root of the Json), it's ok, and I can see the Hebrew letters fine.
For example –
{
"ID_TALMID": 1,
"NAME": "ליאור",
"ADDRESS_LIST": [
{
"CITY_CODE": 950,
"STREET_NAME": "אולפן"
}
]
}
The NAME field under the root displayed ok
The STREET_NAME which is inside a Json field under the root, displayed with "?????"
Hi Alberto I am using your SSIS-Json-Source-Component And I came across a problem with a Json field inside the Json File My problem is that I have Hebrew text in the value (in the inner Json field) And when I try to import the field to my DB (Oracle) I am getting questions marks instead
If there are Hebrew letters in other fields (on the root of the Json), it's ok, and I can see the Hebrew letters fine.
For example – { "ID_TALMID": 1, "NAME": "ליאור", "ADDRESS_LIST": [ { "CITY_CODE": 950, "STREET_NAME": "אולפן" } ] }
The NAME field under the root displayed ok The STREET_NAME which is inside a Json field under the root, displayed with "?????"
Thanks for your help.