Forum Discussion

dp3450's avatar
dp3450
Copper Contributor
Nov 28, 2024

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's avatar
rodgerkong
Iron Contributor
Nov 30, 2024
  1. Save your json file with format UTF-16, instead of UTF-8.
  2. 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))