Stack Overflow
Stack Overflow

Questions tagged [varbinary]

varbinary is the SQL Server datatype used to hold variable-length binary data

SQL Server's varbinary datatype is declared with a length specification in the CREATE TABLE statement:

CREATE TABLE tablename (..., colName varbinary(n), ...)

where n is the maximum size of the column in bytes (limited to a maximum of 8000), or the word MAX if more than 8000 bytes might need to be stored. (The absolute maximum size is approximately 2gb as of this writing; consult SQL Server documentation for the exact current maximum.)

For more information, see this entry in the SQL Server online documentation.

411 questions
2
votes
0 answers

extract data from varbinary compressed cell in mssql db

I have an MS Sql db which is connected to SharePoint 2010 content website. we have .pdf files in blob and meta info compressed with varbinary (dbo.tCompressedBinary(varbinary(max), null)). Can anybody have any idea of how to do it ? In which format…
plasmid
  • 43
  • 10
2
votes
2 answers

How do I convert STRING to VARBINARY in java?

I have a String containing XML tags that I want to convert to VARBINARY and post it to stored procedure in SQL Server. I don't know how to convert a String to VARBINARY. Please advise!
ERP
  • 41
  • 1
  • 1
  • 10
2
votes
1 answer

What's up with SSRS parameters and images?

I'm working on setting up a report in SSRS. Our report is somewhat flexible, and I'm looking to dynamically select an image for a cover page based on a parameter. Here's what I have: In our Reports db I have an image table set up. To keep things…
MattB
  • 2,203
  • 5
  • 26
  • 48
2
votes
1 answer

Getting a sql varbinary record using microsoft enterprise library

I have this line of code byte[] field1 = (reader.GetSqlBinary(reader.GetOrdinal("Field1")).Value; which is a SqlDataReader I am trying to convert the code to use the enterprise library data access block but cant figure out how to get a byte[] using…
Matt
  • 3,664
  • 3
  • 33
  • 39
2
votes
0 answers

Conversion from VARBINARY(max) to VARCHAR(max) truncated SQL- with R

I need to convert from a varbinary(max) datatype to a varchar(max). This is the statement I use: SELECT file = convert(varchar(max), [colFile]) FROM [myTable] where key = 1 This returns a truncated text. If I understood it correctly, it is because…
blfuentes
  • 2,731
  • 5
  • 44
  • 72
2
votes
0 answers

PDO SQLSRV And PDO Dblib Giving Different Result for Varbinary Datatype

$conn = new PDO("sqlsrv:server=$host;Database=$db",$user,$pass); $query = "SELECT TOP 1 CAST(session AS VARBINARY(MAX)) as session FROM t_php_session WHERE php_session_id = '3l7kmpbno002e1vl5sncauhoq3' AND DATEADD(minute, 30, created) >= GETDATE()…
Neeraj
  • 8,625
  • 18
  • 60
  • 89
2
votes
1 answer

Update varbinary(MAX) field in SQLServer 2012 Lost Last 4 bits

Recently I would like to do some data patching, and try to update a column of type varbinary(MAX), the update value is like this: 0xFFD8F...6DC0676 However, after update query run successfully, the value becomes: 0x0FFD8...6DC067 It seems the…
shole
  • 4,046
  • 2
  • 29
  • 69
2
votes
0 answers

SQL Server `like` for varbinary datatype in Entity Framework

I have a table with a column of type varbinary in SQL Server How to get records that contains an array of bytes in this table in Entity Framework? A query like this: var query = from x in context.table where x.varbinaryfield like (byte…
Ali.M
  • 311
  • 6
  • 24
2
votes
4 answers

SQL Server: How to copy a file (pdf, doc, txt...) stored in a varbinary(max) field to a file in a CLR stored procedure?

I ask this question as a followup of this question. A solution that uses bcp and xp_cmdshell, that is not my desired solution, has been posted here. I am new to c# (since I am a Delphi developer) anyway I was able to create a simple CLR stored…
UnDiUdin
  • 14,924
  • 39
  • 151
  • 249
2
votes
3 answers

Permissions for Large Variables to Be Sent Via Stored Procedures (SQL Server)

I can't figure out a way to allow more than 4000 bytes to be received at once via a call to a stored procedure. I am storing images in the table that are around 15 - 20 kilobytes each, but upon getting them and displaying them to the page, they are…
Joe Majewski
  • 1,611
  • 3
  • 18
  • 31
2
votes
1 answer

Database.ExecuteNonQuery does not return

I have a very odd issue. When I execute a specific database stored procedure from C# using SqlCommand.ExecuteNonQuery, my stored procedure is never executed. Furthermore, SQL Profiler does not register the command at all. I do not receive a command…
Dan Waterbly
  • 850
  • 7
  • 15
2
votes
1 answer

SQL Server : exporting varbinary PDF to file on client

I'm using SQL client connected to a SQL Server, and after executing following code, a .pdf file is saved on server HDD not on mine (client). Is there a way to export file to my local harddisk using a query? DECLARE @ImageData varbinary(max); SELECT…
Mienio
  • 99
  • 2
  • 6
2
votes
0 answers

Update sysusers table

I am trying to update the dbo.sysusers table so that the sid matches the dbo.syslogins table but I am getting error: Disallowed implicit conversion from data type varchar to data type varbinary, table 'CallingCard.dbo.sysusers', column 'sid'. Use…
jeffry
  • 327
  • 2
  • 8
  • 23
2
votes
5 answers

Calculate Count of true bits in binary type with t-sql

I need to find how many true bit exists in my binary value. example: input: 0001101 output:3 input: 1111001 output:5
Mostafa Soghandi
  • 1,524
  • 1
  • 12
  • 20
2
votes
2 answers

Symfony2 add new doctrine field type

i lost 3 hours on this thing, and still cant figure out whats wrong, iam trying to add a VARBINARY field type, and doctrine shows me that field as a option when generating new entity, but the problem is when i do php app/console…
michoni
  • 21
  • 3
1 2 3
…
27 28