I like to know the difference between String vs Text in schema. (Also longText , mediumText)
I'm saving about 2000 characters (as a serialised obj) in a column. which schema should I use?
From what I understand String is a varchar and the text(s) reflect their counterparts (in MySQL at least) MySQL Docs
That's correct. String is varchar 255 and the rest of what elite123 said.
@elite123, @ShawnMcCool : thanks!
In case of storing product description, along with their specification such as Size, weight, colour, I'm saving it as Text. Shouldn't be a problem , right?
If you're not going to have a massive amount of products, then it doesn't really matter. I'd generally consider the size requirements of each individual field while designing the schema.
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community