Varchar and Blob

[Anon]

When Should I use varchar or blob
is this ok

item varchar(400) NOT NULL,

or should I use blob since the siz is huge 400

[Anon]

The max length for a varchar is 255 characters, it can not hold 400....

However, blob is mainly used for binary data, you should use text field type instead (it has the same max length as blob does, but it will not hold binary data, which I'm assuming you are just holding text)...

[Anon]

I have already made it as blob. is it ok or should I change it to text field.

[Anon]

It will be fine as a blob.