Stack Overflow
Stack Overflow

Questions tagged [varbinarymax]

Variable-length binary data type in Microsoft SQL Server, where 'MAX' indicates that the data may hold up to the maximum storage size of 2^31-1 bytes.

142 questions
0
votes
1 answer

Cannot Display image from Sql Server using PHP PDO using Varbinary Max

I have been racking my brain trying to figure out why an image will not display using Php PDO with it stored in Sql Server 2016 as a Varbinary Max field. I use Php 7, and have this working on Php 5 using the same code, but with MySql. I want to move…
ChrisC
  • 1
0
votes
1 answer

T-SQL - Validate BLOB / varbinary(max) data

Data is being migrated from Table A to Table B. Table A has 2 columns - an identity column and a column Content defined as varbinary(max). How can I validate that Table B has been loaded with correct data for Content column? Is T_SQL's EXCEPT…
Maurice
  • 75
  • 1
  • 4
0
votes
4 answers

Is it possible to have a nvarchar(max) and a varbinar(max) fields in same table

I am using SQL Server 2008 R2. I have a table which has several fields including a nvarchar(max) field. When I try and add a new field of type varbinary(max) I get an error message: "Saving changes is not permitted. The change that you have made…
Shiraz Bhaiji
  • 64,065
  • 34
  • 143
  • 252
0
votes
1 answer

How to display/store and retrieve image as varbinary(MAX) using ASP.NET MVC view

I am new to ASP.NET MVC, so kindly excuse for mistakes. I need a view page (index.cshtml) where I can display the image, change/delete the image by storing it in Varbinary(max) column in a SQL Server table. There are these columns in the database…
Ismail Khan
  • 1
  • 1
  • 2
0
votes
1 answer

How to store a file in sql server from winforms c++

MY QUESTION: how do I store a file in a sql server using c++ from a windows form application? MY PROBLEM: I am reading in binary data from a file then opening a connection to a SQL Server 2014. When I send my sql command to the database with the…
shirome
  • 13
  • 3
0
votes
1 answer

Byte data getting truncated before getting inserted/updated into column of datatype varbinary(max)

I am inserting Binary data into the one of my tables with a column having datatype varbinary(max). The total length of the binary data which I am inserting is 610154 characters long. While after inserting the data either through the code or manually…
Ram Mehta
  • 449
  • 1
  • 6
  • 20
0
votes
2 answers

HttpPostedFileBase to varbinary(max)

I have just tried a lot of things that I found but at the end nothing successfull. First I have the next code that just do the things ok but dont save the image. What should I do to save an image into a varbinarymax? and how to show them to the view…
Roberto2790
  • 25
  • 1
  • 11
0
votes
1 answer

Error converting text to varbinary with format 1

I have a spreadsheet of data, which is basically PART_ID and SPECS. The SPECS field is a large character string which, when imported into a temporary table, is stored as NVARCHAR(255). Example: 'Widget', 'This part needs to be heated to 400 degrees…
Howard Price
  • 1
0
votes
0 answers

How to display data(with image) in gridview or treeview having parent child relationship in asp.net

I am fetching data from database which is linked as following. Root->Table 1 Each root can have 'n' number of parents -Table 2 Each parent can have 'n' number of children- Table 3 There is an image associated with each children saved in Table…
user3807950
  • 75
  • 1
  • 9
0
votes
0 answers

Unable to insert documents

I'm trying to insert multiple documents at once. Database used is SQL 2008 My table has Image column type. Now I am forming a datatable in c#, which has around 8-10 columns. One of the column is Byte[] type, where the file content is being saved. I…
Xander Kage
  • 161
  • 16
0
votes
0 answers

SQL Update statement to update document file and photo - varbinary (max)

I wrote a SQL UPDATE statement to update document file and photo stores as varbinary(max) in the DB. At first I got an error saying Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this…
ShanD
  • 91
  • 1
  • 1
  • 11
0
votes
1 answer

CLR Integration function that will take an Image/Varbinary value as input

I am trying to create a CLR integration function in SQL Server 2008 R2 which will read a Image/Varbinary value and return a NVARCHAR(MAX). [Microsoft.SqlServer.Server.SqlFunction] public static SqlString ConvertByteArrToString(SqlBinary…
user3927354
  • 73
  • 1
  • 3
0
votes
0 answers

How to save binary data back as a file from SQL table

I am using Microsoft SQL server database file (file with .mdf extension) as the database. I managed to save files into the SQL table as varbinary(max). Now my question is : How do I get back the files? I am thinking I may still need to use SELECT…
user3437460
  • 17,253
  • 15
  • 58
  • 106
0
votes
1 answer

Deleting varbinary(MAX) from SQL Server column

Please read my entire description before you just blow me off and point me at a similar, but different, problem description/solution!! I have a table (Images) which contains 2 columns -- ID (Identity, primary key) and ImageData (a varbinary(MAX)…
user2247569
  • 21
  • 6
0
votes
1 answer

Varbinary(max) insertion - duplication of varbinary(max) fields between unrelated db records

I'm trying to rough out a concept here and I have an odd problem. For your amusement... In summary: What I want to do is generate an image in C# code, insert it into a varbinary(max) field of a SQL 2012 db, and then display it in an SSRS report.…
user2996466
  • 21
  • 7
1 2 3
…
9 10