MySQL VARCHAR max limit

Forum Moderators: open

Message Too Old, No Replies

MySQL VARCHAR max limit

What's the best way to insert a lot of html/text

apauto

8:16 pm on Oct 18, 2008 (gmt 0)

Hey guys,

I'm planning on setting a field in MySQL to accept product descriptions. I have set a VARCHAR field to 10,000 max length, and I was wondering what the max length of a field like this would be, and if there is a better setup for descriptions that will contain small HTML.

THanks

tumr

8:37 pm on Oct 18, 2008 (gmt 0)

How about 'Text'? (Also, this is version-dependent. Prior to MySQL 5, the max VARCHAR was 255. Now VARCHAR can get up around 65k, the row length limit.)