DECLARE @JSON VARCHAR(MAX) --tried also  NVARCHAR(MAX)
SELECT @JSON = BulkColumn
FROM OPENROWSET 
(BULK 'C:\Users\jsail\Desktop\testCodeUtf8.json', SINGLE_BLOB) AS j    --tried also SINGLE_CLOB and SINGLE_NCLOB
SELECT @JSON AS 'jsonText'

The Uploaded File contains...

to bad, SINGLE_BLOB didnt work.

I use for testing SQLEXPRESS 2017 (SQL Server 14.0.3381). Could it be a difference, when I'd work on the Fullversion on the Server?

I get this Error on version 1.

SINGLE_NCLOB requires a UNICODE (widechar) input file. The file specified is not Unicode.

version 2 changes the letters

I use for testing SQLEXPRESS...

• This reply was modified 3 years, 6 months ago by  Joseph-164998.