How should I post HTM coding?

yoki

Ok I have a dilemma as to the type of one my variables that is posted to a MYSQL database.

The field contains HTML coding that I want to preserve for later use. The number of characters is approximately 3000 to 5000 characters. This field gets posted to MySQL but I'm not sure what type it should be. Text? Blob? Anyone can help me?

rincewind456

Is it a Binary Large Object if not use text

bpat1434

MEDIUMTEXT would work. Blob is for binary information.

BLOB columns are treated as binary strings (byte strings). TEXT columns are treated as non-binary strings (character strings).

All this information can be found in the mySQL manual

MEDIUMTEXT

A TEXT column with a maximum length of 16,777,215 (2⁽²⁴⁾ – 1) characters.

There you have it.

~Brett

rincewind456

Why mediumtext when text holds 65,535 chars which gives a leeway off 60,000+ for the OP

bpat1434

well, when I was looking at it, I thought he said 30 - 50k lines of HTML. Either one, Text or MediumText will do.

~Brett