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
0
votes
1 answer

Differences between Convert in SQL and Convert in C#

I have a C# project connected to a SQL Server Database, and I' m doing a format recognition for file upload. More specifically, I upload files in varbinary and I store they in a column in the Db. When I download they, I want to recognize their…
kirkfrusciante
  • 1
0
votes
1 answer

Varbinary Column

I am inserting varbinary using following SQL: CREATE TABLE [dbo].[documentUpload]( [fileName] [nvarchar](150) NULL, [fileContent] [varbinary](max) NULL, ) INSERT INTO documentUpload (fileName,fileContent) …
Mohammad Kamruddin
  • 3
  • 1
0
votes
1 answer

PetaPoco Varbinary(max) and IdentityColumn

I have problem to get Identity value after inserting row with varbinary(max) column type. Here is the code which I use (according to PetaPoco Page): using (var uow = UnitOfWorkFactory.Create()) { var result = uow.Db.Execute(@"INSERT INTO…
Kamil
  • 149
  • 1
  • 2
  • 10
0
votes
1 answer

Mysql - How can I selecting rows based on binary compare of PART of a blob

I have a table which has a varbinary column I would like to select all rows where the first byte of that data is 0x0b Is there a way to for a query which will select based on the compare of the first byte? Maybe using a 'like'? Thanks
vbbartlett
  • 179
  • 2
  • 14
0
votes
2 answers

convert varbinary to img and show image in mvc4

I write this code for save image in my datebase: public ActionResult Create(Slider slider) { if (ModelState.IsValid) { int Len = Request.Files[0].ContentLength; byte[] fileBytes = new byte[Len]; …
Majid Dehnamaki
  • 174
  • 1
  • 2
  • 13
0
votes
2 answers

Retrieving varbinary output from a query in sql server into classic ASP

I'm trying to retrieve a varbinary output value from a query running on SQL Server 2005 into Classic ASP. The ASP execution just fails when it comes to part of code that is simply taking a varbinary output into a string. So I guess we gotta handle…
user303526
  • 13
  • 5
0
votes
1 answer

Problem retrieving Strings from varbinary columns using HIbernate and MySQL

Here's my scenario. I save a bunch of Strings containing asian characters in MySQL using Hibernate. These strings are written in varbinary columns. Everything works fine during the saving operation. The DB contains the correct values (sequence of…
Florin
  • 319
  • 1
  • 7
  • 21
0
votes
1 answer

SQL Truncation Issue Converting VARCHAR to VARBINARY

I have a fairly simple insert from a csv file into a temp table into a table with an encrypted column. CREATE TABLE table1 (number varchar(32) NOT NULL , user_varchar1 varchar(65) NOT NULL , account varchar(32) NOT NULL) CREATE TABLE…
PuroRock
  • 73
  • 5
  • 12
0
votes
1 answer

How to Perform a Replace on Varbinary data in SQL

I've never had to do this before but I'm looking to do a SQL replace on varbinary data. I'm trying this but it's not successfully replacing, I think because it's treating the data as varchar and then cast back to varbinary. This stemmed from blank…
Matt Weick
  • 332
  • 6
  • 19
0
votes
1 answer

Convert string to varbinary - Comparing the two

I need to covert a string to a varbinary(85), which is the data type in my SQL Server Table (unable to change). The data is for a username and I need to compare the windows user name of a person who logs onto a website with this SQL data entry. An…
user3757987
  • 1
  • 2
0
votes
1 answer

Why does <> operator not work as expected on my varbinary(20) sql data?

I have a MySQL database, it contains a table that contains some data in columns of type varbinary(20) Don't ask me why - it just is and i need to deal with it. This data represents the number of modules a student has completed as part of a course.…
undefined
  • 5,190
  • 11
  • 56
  • 90
0
votes
0 answers

Binding Hashed Password to SQL Prepared Statement

I am having trouble pulling back data from my DB when using a hashed password. I use hash_hmac/sha256 as follows: function get_password_hash($password){ return hash_hmac('sha256',$password,'xxxxxxx',false); } $p is a non-hashed password; with this…
DVCITIS
  • 1,067
  • 3
  • 16
  • 36
0
votes
1 answer

Store Bitmap converted to byte array in Varbinary(MAX) or Image data type of SQL Server

I want to store image in a SQL Server database. I have converted image to byte array, and the data type of column in database is varbinary(MAX) but it didn't work even I have changed its type to Image but I get the same results. I have followed many…
Assassino
  • 31
  • 1
  • 3
  • 11
0
votes
1 answer

SSIS package email with attachments

I'm building an SSIS package that selects a recordset of email data, loops through them, and then emails them out through send mail tasks. I have a table for emails, a table for addresses, and a table for attachments. Right now my SSIS package…
TrevorGoodchild
  • 978
  • 2
  • 23
  • 49
0
votes
2 answers

Write blob sequentially in varbinary column

I have to restore some databases to a remote SQL Server. The problem is that they can be up to a few gb and this will cause an "OutOfMemory" exception when reading all bytes at one time. On smaller databases it is working without problems.. Now I…
Relax
  • 283
  • 2
  • 15
1 2 3
…
27 28