What does VARBINARY(MAX) mean?

sql mariadb varbinary varbinarymax
SPlatten picture SPlatten · Oct 21, 2015 · Viewed 19.2k times · Source

I'm trying to port a MSSQL database over to MariaDB and I've encountered a table creation using varbinary(max):

    `definition` VARBINARY(max) NULL DEFAULT NULL

What would this actually do and is there an equivalent type definition in MariaDB that I could use?

Answer

eugenioy picture eugenioy · Oct 21, 2015

As others have stated in the comments, VARBINARY(max) in MSSQL refers to:

Variable-length binary data.

max indicates that the maximum storage size is 2^31-1 bytes.

From what I found in MariaDB's documentation, the only way of getting a similar storage size in MariaDB is to use the LONGBLOB data type:

LONGBLOB

A BLOB column with a maximum length of 4,294,967,295 bytes or 4GB (2^32 - 1).

Useful links:

https://msdn.microsoft.com/en-us//library/ms188362.aspx

http://www.techonthenet.com/mariadb/datatypes.php

Related questions

ERROR 1452: Cannot add or update a child row: a foreign key constraint fails

I have created tables in MySQL Workbench as shown below : ORDRE table: CREATE TABLE Ordre ( OrdreID INT NOT NULL, OrdreDato DATE DEFAULT NULL, KundeID INT DEFAULT NULL, CONSTRAINT Ordre_pk PRIMARY KEY (OrdreID), CONSTRAINT Ordre_fk FOREIGN KEY (KundeID) REFERENCES …

Read More
Cast int to varchar

I have below query and need to cast id to varchar Schema create table t9 (id int, name varchar (55)); insert into t9( id, name)values(2, 'bob'); What I tried select CAST(id as VARCHAR(50)) as col1 from t9; select CONVERT(…

Read More
MySQL - SELECT * INTO OUTFILE LOCAL ?

MySQL is awesome! I am currently involved in a major server migration and previously, our small database used to be hosted on the same server as the client. So we used to do this : SELECT * INTO OUTFILE .... LOAD DATA INFILE .... …

Read More