Page translation with db [closed]

Closed. This question needs to be more focused. It is not currently accepting answers.

---

Want to improve this question? Update the question so it focuses on one problem only by editing this post.

Closed 2 years ago.

Improve this question

I'm creating website in 3 languages and using one table of db for page transl开发者_开发百科ation. I wonder which field type is the best for this reason: varchar, tinytext, text ...? And please explain, why you think so.

---

TEXT is the most appropriate field:
While VARCHAR is limited to 255 65535 characters, TINYTEXT might be too small depending on the lengths of your texts - but if you only use short phrases it would work, too.

However, you should consider using gettext instead of a database.