Provide Nvarchar data type in Fabric Warehouse

[mirimgtec]

I have table as follows :

CREATE TABLE Sample.dbo.VSIF

(

    IDVSIF       int,

    DATEADDED    datetime2(6),

    DATA      VARCHAR(MAX)

)

In DATA i store JSON format string. I need to operate a lot on this column with 

OPENJSON, JSON_VALUE,  JSON_QUERY . However when I use this function i encounter this error :

Cannot resolve collation conflict between "Latin1_General_BIN2" and "Latin1_General_100_BIN2_UTF8" in json_value operator

Fabric Warehouse stores all VARCHAR columns in UTF‑8 (Latin1_General_100_BIN2_UTF8)
OPENJSON always returns NVARCHAR(4000) in non‑UTF8 BIN2 (Latin1_General_BIN2)

It would be better to use NVARCHAR in this database, so i do not put 

COLLATE Latin1_General_BIN2 everywhere when i use JSON_VALUE.