How to use the VarBinary function from mssql

sql-server.js

GitHub: myself11c/ApiCitas_Node

93
94
95
96
97
98
99
100
101
102
case 'sql.DateTime2':        return sql.DateTime2;
case 'sql.DateTimeOffset':   return sql.DateTimeOffset;
case 'sql.SmallDateTime':    return sql.SmallDateTime;
case 'sql.UniqueIdentifier': return sql.UniqueIdentifier ;
case 'sql.Binary':           return sql.Binary;
case 'sql.VarBinary':        return sql.VarBinary;
case 'sql.Image':            return sql.Image;
case 'sql.UDT':              return sql.UDT ;
case 'sql.Geography':        return sql.Geography;
case 'sql.Geometry':         return sql.Geometry ;

0

0

0

+ 5 other calls in file

products.js

GitHub: vnowacki/mssqlPlaygroundApi

118
119
120
121
122
123
124
125
126
127
if (req.files && req.files.picture && req.files.picture.length) {
    const picture = req.files.picture[0];
    app().then(conn => conn
        .input('id', sql.UniqueIdentifier, id)
        .input('filename', sql.NVarChar(100), picture.filename)
        .input('picture', sql.VarBinary(sql.MAX), picture.buffer)
        .query(`
            INSERT INTO app.pictures (productID, fileneme, picture)
            VALUES (@id, @filename, @picture)
        `)

0

0

0

+ 3 other calls in file

get-params.js

GitHub: ImoucheG/machinepack-sqlserver-adapter

145
146
147
148
149
150
151
152
153
154
  break;
case 'uniqueidentifier':
  type = mssql.UniqueIdentifier();
  break;
case 'varbinary':
  type = mssql.VarBinary(columnProperty.CHARACTER_MAXIMUM_LENGTH);
  break;
case 'xml':
  if (currentValue.includes('<?xml')) {
    currentValue = currentValue.substr(currentValue.indexOf('?>') + 2,

0

0

1

+ 7 other calls in file