Member Avatar for nil_gh_80

I want to create a table, with a column which datatype will be LONG BLOB, what will be it's size?????
e.g.
create table tab1(name varchar(20), pic longblob(?????????));

plz give me the currect code...........

  • 3 Contributors
  • 2 Replies
  • 132 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by Dani
Member Avatar for Ezzaral

Why do you need to specify the size? Why must it be a longblob instead of just blob? If you have the answer to the questions then you know what size to set. This really depends on the data that you are going to store. Perhaps you need to read the documentation on the blob data type in MySQL.

Member Avatar for Dani

I don't believe you need to specify a size with blobs.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.