Questions tagged as 'varbinary'

3
answers

How to insert an extended value into a table in a column of type varbinary?

A table has a varbinary (max) column, I need it to have an entry with 400MB of data in this column. How do I create this data? Does the Insert statement have to have the data in full or can I use a loop or a function that manages this data...
asked by 12.12.2013 / 13:09
2
answers

Login using Entity with password encrypted as varbinary

I have encrypted the user's password and in the Password field of my table I went from Varchar to Varbinary, in the web part of my system everything is fine only in the windows part I am using Entity and I do not know how to do it validate the u...
asked by 01.07.2014 / 21:18
1
answer

Why does binary conversion from SQL Server not return a binary value?

Why do I use the following command in SQL Server 2005 select convert(varbinary(16),N'123') returns 0x310032003300 and not 1111011 what would be the binary value?     
asked by 09.03.2015 / 14:39
0
answers

Extract file from the database (varbinary) and use it on the web

I have files saved in a column of my bank ( SQLSERVER ) of type varbinary and need to recover these saved files in this column and > show - them in a modal or download - them ; however, I need to do this using JS . Can someone help...
asked by 21.02.2018 / 16:14
1
answer

System.OutOfMemoryException - When Entity Framework is querying very large data of type Varbinary

I'm trying to query a varbinary field that contains a 1.2 Gb file, using Entity Framework . See below: Test database CREATE TABLE [dbo].[BIGDATA]( [id] [bigint] IDENTITY(1,1) NOT NULL, [BIGDATA] [varbinary](max) NULL, CONSTRAINT...
asked by 07.07.2014 / 16:52
2
answers

Save Image in VARBINARY with C # ASP.NET

How do I get an image received on a Form of HTML and write to the bank in VARBINARY with C# ? I'm using C# ASP.NET MVC5 CORE .     
asked by 30.11.2017 / 11:24