I'm parsing data from a JSON File and am having issues when I finally load into my table, the data where there's special characters such as ñ shows as ñ instead. The code is in NVARCHAR and I'm not sure why it's not pulling correctly INSERT INTO @recordsInfo ( messageId, messageType, messageVariation, windowEnvelope, recipientFirstName, recipientLastName, recipientAddressLine1, recipientAddressLine2, recipientCity, recipientState, recipientZip, recipientZipSuffix ) SELECT messageId, messageType, messageVariation, windowEnvelope, recipientFirstName, recipientLastName, recipientAddressLine1, recipientAddressLine2, recipientCity, recipientState, recipientZip, recipientZipSuffix FROM OPENJSON(@ValueR) WITH ( messageId NVARCHAR(100), messageType NVARCHAR(100) '$.messageDetails.messageType', messageVariation NVARCHAR(100) '$.messageDetails.messageVariation', windowEnvelope NVARCHAR(100) '$.messageDetails.windowEnvelope', recipientFirstName NVARCHAR(100) '$."shippingDetails"."recipientFirstName"', recipientLastName NVARCHAR(100) '$."shippingDetails"."recipientLastName"', recipientAddressLine1 NVARCHAR(1000) '$.shippingDetails.recipientAddressLine1', recipientAddressLine2 NVARCHAR(100) '$.shippingDetails.recipientAddressLine2', recipientCity NVARCHAR(100) '$.shippingDetails.recipientCity', recipientState NVARCHAR(100) '$.shippingDetails.recipientState', recipientZip NVARCHAR(100) '$.shippingDetails.recipientZip', recipientZipSuffix NVARCHAR(100) '$.shippingDetails.recipientZipSuffix' ); RecipientFirstName is the primary one I'm looking at