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

Python Pyodbc Binary Column is returning \xda\x08\xcd\x08\xba\x08 instead of numbers

I have a SQL database that displays a varbinary (max) like this 0x9406920691068F... I want to import it to python pycharm to get the same exact type of data. However, it shows something like this…
Crn
  • 45
  • 1
  • 8
2
votes
3 answers

Storing VARBINARY in a VARCHAR column

Please go through this code: DECLARE @EncryptedPassword VARBINARY(8000) = ENCRYPTBYPASSPHRASE('ABCD','password') DECLARE @Setting AS TABLE (ID INT, Value VARCHAR(MAX)) INSERT INTO @Setting VALUES (1, 'true') INSERT INTO @Setting VALUES (2,…
Harsha W
  • 3,162
  • 5
  • 43
  • 77
2
votes
1 answer

SqlDataReader: Read varbinary into byte array

I have a SQL Server table with a varbinary(max) column. I use it to store images in it. The images are selected with an OpenFileDialog, translated into a byte[] like this public byte[] ConvertImageToByteArray(String filepath) { try { …
farosch
  • 210
  • 4
  • 16
2
votes
1 answer

Working with Binary Data in MySQL

SELECT 0x0000987C As col1, substr(BinaryData,1,4) As col2, CAST(0x0000987C AS SIGNED) As col3, CAST(substr(BinaryData,1,4) AS SIGNED) As col4 FROM ( SELECT 0x0000987C00000000 AS BinaryData ) d Returns col1 col2 col3 …
Martin Smith
  • 438,706
  • 87
  • 741
  • 845
2
votes
1 answer

H2. Insert String to VARBINARY(255)

I have problems with adding data to h2 table, into a column of type VARBINARY(255). Table USER ID BIGINT(19) NOT NULL auto_increment USERNAME VARCHAR(255) NOT NULL PASSWORD VARCHAR(255) NOT NULL ROLES VARBINARY(255) NOT NULL Trying to do…
Бахтияр Сейдахметов
  • 21
  • 2
  • 5
2
votes
0 answers

Mysql Storing hash in varbinary and how to use it after in where clause example

I am newbie in MySQL and I am quite confused en how to insert and after how to retrieve row using this hash in where clause in a varbinary type column. /*sql*/ CREATE TABLE my_table(hash_column VARBINARY(32)); //php $hash =…
MTK
  • 3,300
  • 2
  • 33
  • 49
2
votes
1 answer

How to use AES encryption for large values in SQL Server?

I have a SQL Server table tbl with the schema ID int, LongText varbinary(max) And I have the following functions to encrypt/decrypt the LongText when inserting/fetching records. For encrypting: CREATE FUNCTION Encrypt ( @ValueToEncrypt…
Prashant Tiwari
  • 346
  • 1
  • 3
  • 17
2
votes
4 answers

Selecting not null column

I have a table with varbinary(max) column and nvarchar(max) column. One of them is null and the other has a value. I would like to return the column that has the value as a varbinary(max) column. So far I have tried this, that does not work: SELECT…
Shiraz Bhaiji
  • 64,065
  • 34
  • 143
  • 252
2
votes
0 answers

How to render images in SSRS from VARBINARY field in table

I am trying to build a report that simply shows item information with an items' corresponding picture. The images have already been stored in my database as a varbinary data type. However, the images refuse to render in SSRS once the report is ran.…
Anthony Sims
  • 171
  • 4
  • 15
2
votes
1 answer

how to determine size of row in the database

Possible Duplicate: Size of varbinary field in SQL server 2005 In my SQL2005 database, I have a table that has a column varbinary(MAX). How do I tell the size of the rows? Or as an alternative, tell the size of the varbinary field in each row?
yamspog
  • 18,173
  • 17
  • 63
  • 95
2
votes
1 answer

SQL Server 2008 R2 - Converting Varchar(max) value to varbinary(max)

Two different servers, both running SQL Server 2008 R2. On both servers we run the same command: INSERT INTO Docs(IMG64) VALUES (CONVERT(VARBINARY(max), '/9j/4AAQSkZJRgABAQAAAQABAAD...') Naturally, the actual value of Img64 is a lot longer than…
3BK
  • 1,338
  • 1
  • 8
  • 11
2
votes
3 answers

How to pass byte[] from C# as string to SQL Server stored procedure and convert into varbinary(MAX)

In this project, there is a class which wraps ADO.NET for common data access like ExecuteDataReader, ExecuteScalar, etc.. When using these methods to call a stored procedure, it allows you to pass a Dictionary of parameters (string…
thiag0
  • 2,199
  • 5
  • 31
  • 51
2
votes
0 answers

How to pass NULL to VARBINARY parameter in MSSQL pyodbc query

I am attempting to execute a stored procedure via a pyodbc cursor. cursor.execute('EXEC MyProc ?', (None)) Where MyProc takes a VARBINARY parameter. However, I get this error from FreeTDS: pyodbc.DataError: ('22018', '[22018] [FreeTDS][SQL…
joeb1415
  • 527
  • 2
  • 7
  • 12
2
votes
1 answer

Initialize Varbinary datatype in MySQL

In MySQL, I want to declare a default value to a varbinary column. How do I achieve it ? DECLARE result varbinary(8000); SET result = 0x; I used select CHAR_LENGTH(00101) and it gives me a result 3. I am expecting my result to be 5 (number of…
Oggu
  • 323
  • 1
  • 6
  • 18
2
votes
1 answer

Use varbinary to retrieve image to database using FileUpload

Okay so I'm using adding it to the database by using HttpPostedFile postedFile = eventImage.PostedFile; string fileExtension = Path.GetExtension(postedFile.FileName); if (fileExtension.ToLower() == ".jpg" ||…
Stuart
  • 143
  • 1
  • 3
  • 18
1 2 3
…
27 28