Forum Discussion
dp3450
Nov 28, 2024Copper Contributor
Issue with importing json file
I am using the following script to read data from a json file and import into SQL server. Data import works without any issue. However, I noticed that when the json file contains special characters (...
rodgerkong
Nov 30, 2024Iron Contributor
- Save your json file with format UTF-16, instead of UTF-8.
- Open json file with parameter SINGLE_NCLOB instead of SINGLE_CLOB. SINGLE_CLOB returns content as ASCII string(varchar(max)), SINGLE_NCLOB returns UNICODE string(nvarchar(max))