You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Getting: RequestError: The error description is 'An invalid character was found in text content.'
When trying to INSERT 'åäö' chars into my table using multiple rows from an object array asTable.
This one works... query: "INSERT INTO Table (Char) VALUES (@char)", params: { char: { val: 'ÅÄÖ', type: sql.NVARCHAR } }
This one doesn't work ... query: "INSERT INTO Table (Id, Char) " + "SELECT @parentId, value FROM @chars", params: { parentId: { val: 123, type: sql.INT }, chars: { val: [ 'å', 'ä', 'ö'], type: sql.NVARCHAR, asTable: true }
And this doesn't work... query: "INSERT INTO Children (Id, Char) " + "SELECT @parentId, char FROM @chars", params: { parentId: { val: 123, type: sql.INT }, chars: { val: [ { char: 'å' }, { char: 'ä' }, { char: 'ö' } asTable: { char: sql.NVARCHAR, } } }
The text was updated successfully, but these errors were encountered:
Getting:
RequestError: The error description is 'An invalid character was found in text content.'
When trying to INSERT 'åäö' chars into my table using multiple rows from an object array asTable.
This one works...
query: "INSERT INTO Table (Char) VALUES (@char)", params: { char: { val: 'ÅÄÖ', type: sql.NVARCHAR } }
This one doesn't work ...
query: "INSERT INTO Table (Id, Char) " + "SELECT @parentId, value FROM @chars", params: { parentId: { val: 123, type: sql.INT }, chars: { val: [ 'å', 'ä', 'ö'], type: sql.NVARCHAR, asTable: true }
And this doesn't work...
query: "INSERT INTO Children (Id, Char) " + "SELECT @parentId, char FROM @chars", params: { parentId: { val: 123, type: sql.INT }, chars: { val: [ { char: 'å' }, { char: 'ä' }, { char: 'ö' } asTable: { char: sql.NVARCHAR, } } }
The text was updated successfully, but these errors were encountered: