Drizzle ORM BLOB column data type in MySQL

Question

I want to create a BLOB data type to store a PDF file which unknown file size. How can I create BLOB column in Drizzle?

The closest data types supported by Drizzle are BINARY and VARBINARY (see here) which require the max length. Meaning I need to specify a maximum size and hoping that user will not store a PDF bigger than that.

Answer 1

How abou to use Varbinary in mysql?

https://orm.drizzle.team/docs/column-types/mysql#varbinary

since it says in the Mysql Doc.

In most respects, you can regard a BLOB column as a VARBINARY column that can be as large as you like.