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

Issue with saving files into SQL as varbinary(max)

So, I have a web application that saves some attachments into SQL database as VarBinary(max), everything working smoothly until I realized that when I download the attachment from the database, the file is very big comparing to the original size, so…
Osama Gadour
  • 177
  • 2
  • 17
0
votes
0 answers

Python to SQL Server insert query to varbinary(max) column

I am performing an insert query from Python (3.6) to SQL Server. I am trying to insert a bytes datatype into a varbinary(max) column. Now, the query executes successfully but value in the SQL Server column is not correct. Not sure what I am…
Akshay
  • 1
  • 2
0
votes
1 answer

Python MS-SQL query not returning a correct value for varbinary datatypa coulmn

I can successfully connect to SQL server database with python script, execute the query and store the output in a dataframe, however, there are few columns with varbinary(max) datatype in the DB which do not return the column in the right format in…
A Potdar
  • 3
  • 4
0
votes
0 answers

Technical difference between varbinary(8000) and varbinary(max) in SQL Server?

Except for the different amount of data it can store, what is the implementation / storage difference between varbinary(8000) and varbinary(max) in SQL Server 2019? The official docs just say to use varbinary(max) for column data with more than 8000…
stefan.at.kotlin
  • 15,347
  • 38
  • 147
  • 270
0
votes
0 answers

PHP: Unable to save converted binary value into SQL Server database (Implicit conversion error)

I am trying to write an image into an SQL Server database in binary format with no success. The image uploaded from my frontend (AngularJS) to my server (PHP) is a Base64 string and I need to then convert it to a raw binary file starting with 0x as…
Riples
  • 1,167
  • 2
  • 21
  • 54
0
votes
0 answers

Calling MySQL stored procedure that takes longblob/varbinary(max) param from MS SQL Server

I am trying to call a MySQL stored procedure via linked server from MS SQL Server. The MySQL stored procedure will insert records that contain longblobs (coming in from MS SQL Server as VARBINARY(Max). I'm not sure if I have the quotes correct…
cwk1999
  • 21
  • 3
0
votes
0 answers

Update VARBINARY(max) column using data from a different table - what exactly is copied?

I have an old data table in SQL Server 2017 containing a VARBINARY(max) column, say [doc].[final], the size of the value could be as large as 500MB. Now I want to create the VARBINARY(max) value in a different table first, say…
Diesel S
  • 1
  • 1
0
votes
1 answer

Passing parameters to Insert statement in PostgreSQL

I have a WCF windows service and that service is used to do the CURD operation over PostgreSQL. Now I am trying to pass dynamic parameters to insert or update statements in PostgreSQL. I have built a string at the client end with the query and…
teja
  • 69
  • 1
  • 10
0
votes
1 answer

C# Extract File From varbinary(max) field - file is corrupted

Problem: I have a database, that has files in a varbinary(max) column. I know the type of file because there is an extension field. I need to pull the data out and save the files to the filesystem. I don't have a whole lot of information about…
cmartin
  • 2,819
  • 1
  • 26
  • 31
0
votes
2 answers

Store a dynamic list of images in 1 row

I am joining these two tables and I would like to send a view of the Test with its image(s). Test Name (VARCHAR(255)) TestId (INT) StartTime (DATETIME2(7)) Status (VARCHAR(255)) Images ImageId (INT) TestId (INT) Image (VARBINARY(MAX)) Right…
vvilin
  • 185
  • 10
0
votes
1 answer

Error: locale . How can I fix this error?

I am trying to save the varbinary[max] column in my database. For this, I have this code below: public static void databaseFilePut(string varFilePath) { byte[] file; using (var stream = new FileStream(varFilePath,…
Unknown
  • 145
  • 2
  • 11
0
votes
5 answers

C# : Saving an Image into DB

Can someone give me some advice on how to save an image file into DB in C#? I will be saving a lot of images so what's the best way to reduce the space it will be needing? I'm currently using varbinary(max) field in DB. Thanks!
Jerald
  • 199
  • 2
  • 6
  • 12
0
votes
1 answer

How to insert an Excel file to a column with varbinary type into an SQL table?

I have a table: Formats with columns: FileName,Document_binary,Format,UsedBy,Date and Id Document column is VARBINARY(MAX). There are some already loaded documents with names like: 0x504b34xxxx and so on, all of these are excel files that users can…
user3412266
  • 71
  • 1
  • 3
  • 8
0
votes
0 answers

Microsoft SQL Server and varbinary data type conversion

I'm not familiar with Microsoft SQL Server and the varbinary(max) data type but the database which I need to use stores images as that. My question is what do I need to do to read that data back and convert it back to readable image type? So far I…
JackTheKnife
  • 3,795
  • 8
  • 57
  • 117
0
votes
0 answers

Cannot insert image into SQL Server database from android using PHP

Its been a lot of days i am trying to insert the biometric fingerprint scanned data into MS SQL Server database using android through PHP. I am sharing my entire code this time , i have to complete it anyhow. Please friends help me out solving…
java bee
  • 115
  • 3
  • 15
1 2 3
…
9 10